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 rename an existing table?

1104

---

How to connect to a local oracle 10g xe server?

977

---

How to use fetch statement in a loop?

1007

---

Explain the use of control file?

1095

---

What is parameterized cursor in oracle?

1118

---

How do I limit the number of oracle database connections generated by weblogic server?

1053

---

Explain integrity constraints?

1090

---

How is it different from a normal table?

1009

---

Explain the use of Merge statement in oracle 11g

1011

---

What is Trigger in Oracle?

1137

---

How to synchronize 2 schema's objects?

2153

---

What is a cognitive schema?

949

---

what is the difference between restoring and recovering?

998

---

ABOUT IDENTITY?

2034

---

How do I manually uninstall oracle client?

1070

---