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

How to create a new view in oracle?

1024

---

How to update values on multiple rows in oracle?

988

---

How to create a new user account in oracle?

967

---

Explain how you would restore a database using RMAN to Point in Time?

2109

---

What are the ways tablespaces can be managed and how do they differ?

2286

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2002

---

How to rebuild an index in oracle?

982

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

931

---

What is bulk load in oracle?

1015

---

What is program global area (pga) in oracle?

974

---

How to connect the oracle server as sysdba?

1026

---

What is connection pool in oracle?

938

---

How many categories of data types in oracle?

975

---

Can we store images in oracle database?

954

---

What is SQL access advisor in Oracle?

1149

---