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 |
why we use datawarehouse
what is $$$$?
what are 3 tech challenges/ common issues you face?
Which is the t/r that builts only single cache memory?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
how many types of dimensions are available in informatica?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
what is the process of target load planing?
in performance wise union is past,union all is past
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
Explain the flow of data in Iinformatica?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,