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 is a read write transaction in oracle?

1093

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1934

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

---

How to estimate disk space needed for an export job?

1051

---

Explain the different normalization forms?

1103

---

How to create an oracle database?

1042

---

Why we use bulk collect in oracle?

1044

---

Why do you create or replace procedures rather that drop and recreate.

1007

---

What privilege is needed for a user to create views in oracle?

1050

---

How to use "out" parameter properly?

1082

---

What happens if the imported table already exists?

1033

---

WHAT IS ecc 6.0

2148

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

---

Oracle

2378

---

Explain the use of compress option in exp command.

1021

---