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);

How to pass a parameter to a cursor in oracle?

1124

---

What is connection pool in oracle?

944

---

How to open a cursor variable?

989

---

Why does oracle 9i treat an empty string as null?

1000

---

What do database buffers contain?

979

---

what happened to the global index when I truncate the data in one of the partition?

1981

---

Can we store images in oracle database?

959

---

What is save point in oracle database?

1259

---

How to delete all rows a table in oracle?

1027

---

How to assign data of the deleted row to variables?

1026

---

What are the parameters that we can pass through a stored procedure?

1015

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2109

---

master table and child table performances and comparisons in Oracle ?

2097

---

Can group functions be used in the order by clause in oracle?

954

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2920

---