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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shital.mylove@gmail.com
1.Unknown column 'x' in 'field list'
2.1
3.Unknown column 'x' in 'field list'
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venkat
ans 1-->wrong number
ans2-->invalid number
ans3-->wrong number
Is This Answer Correct ? | 3 Yes | 3 No |
What is the difference between lookup override and souce qualifier override ?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
What are the main issues while working with flat files as source and as targets ?
What is incremental aggregation?
Have you worked with/created Parameter file
What is meant by lookup transformation?
what is informatica metadata?
what is the flow?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
How does the aggregator transformation handle null values?
how can we perform incremental aggregation?explain with example?
What is enterprise data warehousing?