Answer Posted / pari

declare
str varchar2(250);
str1 varchar2(250);
begin
select to_char(sysdate,'dd-mm-yyyy hh:mi:ss') into str from
dual;
dbms_output.put_line (str);
str1 := substr(str,instr(str,' ',1)+1 );
dbms_output.put_line (str1);
end;

How to start an oracle instance?

1103

Design database draw er diagram for a certain scenario ?

4656

How to put more than 1000 values into an oracle in clause?

1115

What is oracle latest version?

1174

How to select all columns of all rows from a table in oracle?

1132

How to write a left outer join with the where clause in oracle?

1155

How to use values from other tables in update statements using oracle?

1158

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956