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
- 9267 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
Different circumstance which drives informatica server to expel records?
What is domain and gateway node?
Explain Dataware house architecture .how data flow from intial to end?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
explain about unit testing? in real time?
What is workflow? What are the components of the workflow manager?
What is fact table? Explain the different kinds of facts.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can we remove the duplicates from flat file source?
What are different types of transformations available in informatica?
How many ways are there to create ports?
How to update source definition?
whats the logic to load the lower level of granularity of data to fact table.
What is confirmed fact in dataware housing?
What are the types of caches in lookup? Explain them.
