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
- 8719 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 a joiner transformation and why it is an active one?
Describe expression transformation?
Explain pmcmd command usage in informatica
How can you validate all mappings in the repository simultaneously?
Partition, what happens if the specified key range is shorter and longer
Explain why we use partitioning the session in informatica?
How does a sorter cache works?
Design a mapping to load a target table with the following values from the above source?
What is different between the data warehouse and data mart?
Name the different lookup cache(s)?
Why update strategy and union transformations are active? Explain with examples.
How many ways are there to do 'remove duplicate records in informatica'?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is sq transformation?
What is the use of source qualifier?
