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
- 9243 Views
- HP, I also Faced
- E-Mail Answers
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 session parameters?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
Describe two levels in which update strategy transformation sets?
EXL informatica Questions
Suppose we do not group by on any ports of the aggregator what will be the output?
How to send duplicates to one target and unique rows to one target?target is empty
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
What are the informatica performance improvement tips
Label in Informatica. How to remove existing Label.
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Teradata 
