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 / shital.mylove@gmail.com
1.Unknown column 'x' in 'field list'
2.1
3.Unknown column 'x' in 'field list'
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many transformations can be used in mapplets.
What is flashback table ? Advance thanks
how tokens will generate?
What does role playing dimension mean?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is an aggregator transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to load last n records of file into target table - informatica
Which transformation should we use to normalise the COBOL and relational sources?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How do you load only null records into target? Explain through mapping flow.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is the -ve test case in your project.
Explain the etl program with few examples.
Reusable transformation and shortcut differences