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 are the different editions of oracle?

1108

---

What are the set operators union, union all, minus & intersect meant to do?

989

---

What is blob datatype?

1130

---

What is logical backup in oracle?

1018

---

What is index-organized table in Oracle?

1069

---

How do I know if oracle is installed on windows?

931

---

How do I find the database name in oracle?

1039

---

What is a proxy object?

1063

---

what is the difference between data migration and production migration.

2346

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2623

---

How to fetch the row which has the max value for a column?

1002

---

How to insert multiple rows with one insert statement in oracle?

1087

---

What does sharding mean?

1001

---

Can we call procedure inside function in oracle?

1096

---