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
- 9390 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 |
how to import multiple flat files in to single target where there is no common column in the flat files
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we run session without using workflows?
How do you load alternate records into different tables through mapping flow?
I want load the data into target with out 1st and last record.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How might you approve all mappings in the archive all the while?
When to use normalization transformation other than cobol source?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
Why we require dwh in particular projects?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
can you please explain me pre session and post session options?
Teradata 
