in oracle write query yourname+1 from dual
Answers were Sorted based on User's Feedback
Answer / babu
it displays the error message is
"yourname": invalid identifier
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
What are the join types in joiner transformation?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
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
What is the status code in stored procedure transformation?
What are the uses of etl tools?
How can you join two tables without any common column present in them?
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
When to use normalization transformation other than cobol source?
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
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?
What is Code Page Compatibility?