Explain temporal data types in oracle
- 1 Answers
- 1172 Views
- I also Faced
- E-Mail Answers
Answer / Rupesh Tiwari
Temporal data types in Oracle are special types of data used to store and manipulate date, time, and datetime values. These include DATE, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, and TIMESTAMP WITH TIME ZONE. They provide built-in functions for calculating intervals between dates, converting date and time formats, and determining the day of the week or month.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to do paging with oracle?
What operating systems are supported by oracle database 10g xe?
Explain the characteristics of oracle dba?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
Display Odd/ Even number of records?
How to define an anonymous block?
what is kernel?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How would you optimize a slow SQL query?
What does ROLLBACK do ?
What are the different type of Segments ?
How to display employee records who gets more salary than the average salary in the department?
Oracle General 
