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

Explain about integrity constraint?

1108

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2064

---

Why does for update in oracle 8 cause an ora-01002 error?

983

---

Explain the use of owner option in exp command.

1027

---

How do I uninstall oracle client from windows?

1000

---

How to convert character types to numeric types?

1096

---

How to shutdown your 10g xe server from command line?

1066

---

does the query needs a hint to access a materialized view?

1844

---

What is difference between cartesian join and cross join?

1070

---

How to use subqueries in the from clause in oracle?

1088

---

How to fetch the row which has the max value for a column?

983

---

What is oracle used for?

1007

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2317

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2335

---

How would you go about verifying the network name that the local_listener is currently using?

2027

---