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?

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


Please Help Members By Posting Answers For Below Questions

What is a joiner transformation and why it is an active one?

799


Describe expression transformation?

891


Explain pmcmd command usage in informatica

928


How can you validate all mappings in the repository simultaneously?

1079


Partition, what happens if the specified key range is shorter and longer

2245


Explain why we use partitioning the session in informatica?

831


How does a sorter cache works?

831


Design a mapping to load a target table with the following values from the above source?

1123


What is different between the data warehouse and data mart?

856


Name the different lookup cache(s)?

951


Why update strategy and union transformations are active? Explain with examples.

1000


How many ways are there to do 'remove duplicate records in informatica'?

808


What are the types of schemas we have in data warehouse and what are the difference between them?

751


What is sq transformation?

882


What is the use of source qualifier?

905