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
- 9391 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
How do you load unique records into one target table and duplicate records into a different target table?
What is a mapplet/worklet in informatica?
What is depict expression change?
How are the sources and targets definitions imported in informatica designer?
How do you use reject loader.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is native users?
What is InformaticaPowerCenter?
Define pmcmd command?
Explain dynamic target flat file name generation in informatica
What are the measure objects?
Which is the t/r that builts only single cache memory?
Explain load alternative records / rows into multiple targets - informatica
What is the meaning of decode in informatica?
Explain sessions. Explain how batches are used to combine executions?
