in oracle write query yourname+1 from dual

Answer Posted / babu

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

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3444


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1455


State the limitations where we cannot use joiner in the mapping pipeline?

544


What are the main issues while working with flat files as source and as targets ?

648


What is a filter transformation?

564






How do you convert single row from source into three rows into target?

602


What is a snowflake schema?

565


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1699


how to load rows into fact table in data warehouse

637


What is the use of target designer?

602


What are the different ways to implement parallel processing in informatica?

859


What is workflow manager?

571


How do we call shell scripts from informatica?

593


Is stop and abort are same in informatica?

569


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1740