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 view the tablespaces in the current database?

924

---

What is data type in oracle?

1037

---

How to turn on or off recycle bin for the instance?

1007

---

How to create a table index?

1059

---

How to define an external table with a text file?

1018

---

What is hash cluster in oracle?

1083

---

Why do you create or replace procedures rather that drop and recreate.

943

---

How to view all columns in an existing table?

869

---

How to select some rows from a table in oracle?

1002

---

How to update a table row with a record?

960

---

How do we create privileges in oracle?

990

---

How to compare dates in oracle sql?

1040

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2994

---

What is catalog in Oracle?

1263

---

What is a connect identifier?

981

---