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);
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the use of online redo log files in oracle.
What privilege is needed for a user to insert rows to tables in another schema?
ABOUT IDENTITY?
How to define a record variable to store a table row?
What is a trigger and what are its types in oracle?
What is query image?
Does facebook use oracle?
What are data pump export and import modes?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain index?
What is the best way to do multi-row insert in oracle?
Explain view?
What are the attributes of cursor?
What is MTTR advisor in Oracle?
Can we save images in a database and if yes, how?