Answer Posted / nannesaheb c

There is no such data type is existed in Oracle to store the time in a column directly.

However we can insert the time value in a column using the sql functions as below.

SELECT substr(to_char(sysdate,'DD-MON-YYYY HH:MM:SS'),12,20) FROM dual;

create table time1
(
today_time varchar2(10)
);
insert into time1 values(substr(to_char(sysdate,'DD-MON-YYYY HH:MM:SS'),12,20));

Regards,
Nanne

what is reindexing?

1662

---

How to return top 5 rows in oracle?

1046

---

Does oracle partitioning improve performance?

983

---

How to get maxsal , minsal, ename department wise in single query

1543

---

Explain the use of indexes option in exp command.

1134

---

How a tablespace is related to data files?

1099

---

State the various uses of dbcc command?

1048

---

What is oracle open database communication (odbc)?

1017

---

What are the built-in functions used for sending Parameters to forms ?

3374

---

Explain the use of indexes option in imp command.

1164

---

Explain mutating triggers.

1022

---

Can group functions be used in the order by clause in oracle?

990

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2244

---

How to change user password in oracle?

1018

---

Explain the use of parfile option in exp command.

1060

---