Interested to Buy Any Domain ? << Click Here >> for more details...
My sql query is
1. select 1+x from dual?
2. select 1+'x' from Dual?
3. Select x+1 from dual?
what is the out put of the above queries?
- 3 Answers
- 9121 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / jafar
Hello;
I am not a DBA but I do not think you can use variables like
this. But I ran the SQL and the out put for them was the same:
ORA-00904: "X": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
You can do things like:
Select 1+1 from dual;
Select sysdate from dual
select sysdate - 300 from dual;
select user from dual;
Hope that helps.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the size of your data warehousing?
How many numbers of sessions can one group in batches?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Define mapplet?
Differentiate between a repository server and a powerhouse?
how to create user defined function (udf) in informatica
What do you understand by SOA of Informatica?
How to create a non-reusable instance of reusable transformations?
have u done any performance tuning? how u ll do?
How can we delete duplicate rows from flat files?
Sequence generator, when you move from develoment to production how will you reset
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is mapplet in informatica?
What is persistent lookup cache?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
