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

Answer / ns

select to_char(systimestamp,'HH24:MM:SS') from dual;

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

How can we delete duplicate rows in a table?

0 Answers  

---

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,

---

What privilege is needed for a user to insert rows to tables in another schema?

0 Answers  

---

how to find the second highest salary in a given table????

5 Answers  

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

Can a property clause itself be based on a property clause ?

1 Answers   Oracle,

---

In oracle there is column command, how will you explain that?

0 Answers   Aricent,

---

Explain the use of full option in exp command.

0 Answers  

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---