Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / chandumba2005

Answers were Sorted based on User's Feedback



My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1..

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

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1..

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

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1..

Answer / venkat

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

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

generate date / time dimension in informatica

0 Answers   Informatica,

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

Briefly explain the aggregator transformation?

0 Answers  

when we dont use aggregator in mapping ?

2 Answers   CSC,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

For more Informatica Interview Questions Click Here
Categories