Answer Posted / sudipta santra

No problem, There are 2 ways for doing this:

1. If the field of the table is timezone then you can set
data or insert data of timezone i.e the timezone is upto
milliseconds.

eg. insert into timetab(time_col) values(select
sysdbtimezone from dual);

2. If the field is varchar2 then you can set the value or
insert the time stamp like that:

insert into timetab(time_col)
values(substr(to_char(sysdate,'DD-MON-RRRR'),13);

What are the components of logical database structure in oracle database?

1020

---

What operating systems are supported by oracle database 10g xe?

982

---

What is meant by joins?

1011

---

What is the difference between hot backup and cold backup in oracle?

951

---

Why do we use bulk collect in oracle?

1007

---

What is the usage of synonyms?

1057

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2042

---

What is backup in Oracle?

949

---

How to create a single index for multiple columns?

973

---

How to insert a record into a table?

1018

---

Explain the use of record length option in exp command.

1019

---

What is query image?

921

---

What is the sql query to concatenate column values from multiple rows in oracle?

995

---

Why do we need oracle client?

881

---

How to open and close an explicit cursor in oracle?

994

---