in oracle write query yourname+1 from dual

Answers were Sorted based on User's Feedback



in oracle write query yourname+1 from dual..

Answer / babu

it displays the error message is
"yourname": invalid identifier

Is This Answer Correct ?    7 Yes 0 No

in oracle write query yourname+1 from dual..

Answer / moorthy g

It Displays the following Messages:
>> select moorthy+1 from dual

ERROR at line 1:
ORA-00904: "MOORTHY": invalid identifier

Is This Answer Correct ?    3 Yes 0 No

in oracle write query yourname+1 from dual..

Answer / smitha

select 'smitha+1' from dual;

Is This Answer Correct ?    2 Yes 0 No

in oracle write query yourname+1 from dual..

Answer / uma

select 'umadevi'||'+'||1 from dual;

Is This Answer Correct ?    3 Yes 2 No

in oracle write query yourname+1 from dual..

Answer / abhinaw prakash

Select 'Abhi'||'+1' from Dual

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,


On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  


Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,


Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  


Explain what is informatica metadata and where is it stored?

0 Answers  


what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


difference between shortcut and reusable transformation?

2 Answers  


What are Dimensional table?

0 Answers   Informatica,


What is confirmed dimension and fact?

7 Answers  


Categories