Answer / zaheer

No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time

Answer / 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 do we create privileges in oracle?

0 Answers  

---

how to truncate date and get only time part 9:20:00

5 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

How to drop an existing view in oracle?

0 Answers  

---

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

0 Answers  

---

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

Explain the use of show option in imp command.

0 Answers  

---

What is tns entry?

0 Answers  

---

what's query optimization and without use of IN AND Exist can we get another way data from query

0 Answers  

---

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

---

How to define a variable of a specific record type?

0 Answers  

---