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
- 8655 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
What is data caches/ index caches?
Explain informatica architecture - version 8 / 9
What are the mapping parameters and mapping variables?
what are 3 tech challenges/ common issues you face?
Why is sorter an active transformation?
COM components can be used in Informatica
how to create user defined function (udf) in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to delete duplicate row using informatica?
What are the popular informatica products?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the modules in Power Center
Mention a few design and development best practices for informatica?
What is complex mapping?
