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 the difference between translate and replace?

1112

---

How to write numeric literals in oracle?

1231

---

Can I create users through internet explorer in oracle 10g?

1152

---

How do I escape a reserved word in oracle?

1253

---

How to use "while" statements in oracle?

1374

---

How do you tell what your machine name is and what is its IP address?

2154

---

Who developed oracle & when?

1054

---

What is dynamic proxy?

1044

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2353

---

Explain what does a control file contain?

1157

---

What are the differences between interval year to month and interval day to second?

1059

---

What are the differences between blob and clob in oracle?

1133

---

What is sequence?

1133

---

How to write a left outer join with the where clause in oracle?

1127

---

What is the difference between 10g OEM and 11g OEM?

1015

---