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
- 9247 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
Explain the different lookup methods used in informatica?
Briefly explain the aggregator transformation?
In development project what is the process to follow for an etl developer from day1
While migrating the data from one environment to another environment how would you manage the connections?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the sequence generator transformation in informatica?
What does update strategy mean, and what are the different option of it?
Explain joiner transformation in informatica
what is the size of u r source(like file or table)?
Explain why we use partitioning the session in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Explain sessions. Explain how batches are used to combine executions?
How do you promote a non-reusable transformation to reusable transformation?
What is enterprise data warehousing?
COM components can be used in Informatica
