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

Does oracle partitioning improve performance?

1048

---

What is null value in oracle?

1154

---

How to use "startup" command to start default instance?

1094

---

Can select statements be used on views in oracle?

1082

---

WHAT IS ecc 6.0

2197

---

What is the maximum number of triggers that can be applied to a single table?

1065

---

How to select some rows from a table in oracle?

1121

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1930

---

How to retrieve values from data fields in record variables?

1166

---

How can I combine multiple rows into a comma-delimited list in oracle?

1112

---

How to update values on multiple rows in oracle?

1073

---

Hi Can any one tell me what are the API's used in requisition import.

1964

---

State and explain about oracle instance?

1046

---

How to define a sub function?

1194

---

How to use null as conditions in oracle?

1121

---