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
- 9091 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
Define mapplet?
What is Data Caches size?
What are the advantages of informatica?
What is lookup change?
How do you convert single row from source into three rows into target?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what is the complex transformation you used in informatica
What do think which one is the better joiner or look up?
What is the commit type if you have a transaction control transformation in the mapping?
What is a predefined event?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the guidelines to be followed while using union transformation?
Explain the different lookup methods used in informatica?
Mention a few design and development best practices for informatica?
What are the different options available for update strategy?
