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 |
Explain how to import oracle sequence into informatica?
Can we run session without using workflows?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
What is repository manager?
how to identify new and old values in source qualifier or any other transformations using informatica
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
how to declare array in plsql?
why dimenstion tables are denormalized in nature ?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?