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

how to truncate date and get only time part 9:20:00

Question Posted / parna

Answer Posted / parna

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the different oracle database objects?

1091

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1918

What is Reduced List of Values?

2166

Explain the use of control file?

1113

What happens if the imported table already exists?

1033

is there a tool to trace queries, like profiler for sql server?

1141

How to define a record variable to store a table row?

1058

Explain database link?

1125

How to create a new tablespace in oracle?

987

Explain what does a control file contain?

1098

How to convert numbers to characters in oracle?

1030

What are the different types of synonyms?

1140

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4595

What do you mean by a deadlock?

1065

Explain the use of record option in exp command.

1006