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

What are the join types in joiner transformation?

1 Answers   Informatica,


In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


What is the status code in stored procedure transformation?

0 Answers   Informatica,


What are the uses of etl tools?

0 Answers  






How can you join two tables without any common column present in them?

1 Answers   TCS,


PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  


When to use normalization transformation other than cobol source?

2 Answers  


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  


What is Code Page Compatibility?

1 Answers  


Categories