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 / venkat

ans 1-->wrong number
ans2-->invalid number
ans3-->wrong number

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain one complex mapping with logic? sales project?

6140


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1730


What are the modules in Power Center

1225


Separate from a database, an information bazaar, and an information stockroom?

603


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6068






What is meant by incremental aggregation?

578


Where can we find the throughput option in informatica?

599


What are Dimensional table?

606


Write the different tools in the workflow manager?

569


difference between repository database and repository service?

616


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5234


How to load a Dimension ? and how to load a fact table?

949


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9161


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7763


tell me about your project functionality

1859