Data types in Oracle 9i

Data types in Oracle 9i

Cn anyone tell me the difference between timestamp wih time zone and timestamp with local timezone datatypes in oracle 9i.
View Answers

February 15, 2010 at 5:18 PM

Hi Friend,

On Using TIMESTAMP WITH TIME ZONE, oracle store timezone information along with the month, day, year, hours, minutes, seconds, and fractional seconds whereas on using TIMESTAMP WITH LOCAL TIME ZONE,oracles does not stored any time zone information.

Thanks









Related Tutorials/Questions & Answers:
Data types in Oracle 9i - SQL
Data types in Oracle 9i  Cn anyone tell me the difference between timestamp wih time zone and timestamp with local timezone datatypes in oracle 9i.  Hi Friend, On Using TIMESTAMP WITH TIME ZONE, oracle store timezone
how to download oracle 9i
how to download oracle 9i  how to download oracle 9i
Advertisements
Oracle 9i free download
Oracle 9i free download  where to download oracle 9i for database connectivity in j2ee
Oracle 9i database problem
Oracle 9i database problem  Hi Somebody has given the solution but i... Oracle 9i in my laptop.and i got sql+ page ok.i have gone to control panel->odbc->in that i correctley configured DNS and TNS and tested the Oracle
create archive file on local disk in oracle 9i
create archive file on local disk in oracle 9i  how to create archive file on local disk and insert it in the oracle 9i database by java and MySQL. plz send to whole description all about this urgently. Thanks
How to use Bean Area in Oracle Forms 9i with Sample code ?
How to use Bean Area in Oracle Forms 9i with Sample code ?  Hi friend.I posted a query,but I didn't get the answer for it.Help me to resolve including a bean area in oracle forms 9i and using it in forms.Thanks in advance.Help me
what is difference b/w oracle 8i, 9i and 10g
what is difference b/w oracle 8i, 9i and 10g  what are the difference between oracle 8i,9i and 10g? I am not considering the versions and their supported os, in the interview point of view
oracle data backup
oracle data backup  how to take oracle tables data backup and use in another system
data types
data types  Write a short note on data types of Java.   Please visit the following link: Java datatypes
oracle data science
oracle data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: oracle data science... the topic "oracle data science". Also tell me which is the good training
oracle data scientist
oracle data scientist  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: oracle data... the topic "oracle data scientist". Also tell me which is the good
oracle data science cloud
oracle data science cloud  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: oracle data... learn the topic "oracle data science cloud". Also tell me which
servlet program for data store in oracle?
servlet program for data store in oracle?  how to store data in oracle through servlet program
Numeric Data Types
Numeric Data Types  Compare numeric data types of java with corresponding data types in C
JavaScript Data Types
JavaScript Data Types  What are JavaScript Data Types
Hibernate Data types
This section lists Hibernate data types
Data types in a table
Data types in a table  hii, What are the data types allowed in a table?   hello,,ADS_TO_REPLACE_1 These are the data types in table..._TO_REPLACE_2 These are the data types in table:- VARCHAR2, CHAR, NUMBER, RAW
Are arrays primitive data types?
Are arrays primitive data types?   Hi, Are arrays primitive data types? thanks   Hi, In Java, Arrays are objects. Identifier are some... as primitive data type
Data Types in Java 7
In this section we will discuss Java 7 Data Types
Declaring Data Types in Java
Declaring Data Types in Java  What is the best way of declaring data types in Java?   http://www.roseindia.net/java/master-java/java-data... named 'byteident' which primitive data type is byte."); System.out.println
size of different basic data types
size of different basic data types   Write a simple program to find the size of different basic data types in java
retrive data from oracle to jsp
retrive data from oracle to jsp  i am a beginer in jsp so please help... cost and manager name and storing it in the data base. in search proj fiel... connected to data base
Java Data Types
Java Data Types      ... on it. There are seven more primitive data types which are supported by Java language... is predefined in Java. Following are the eight primitive data types: int It is a 32-bit
Primitive Data Types
In this section we will discuss about Primitive Data Types in Java 7
Reference Data Types
In this section we will discuss about Reference Data Types in Java 7
What are the data types allowed in a table?
What are the data types allowed in a table?  What are the data types allowed in a table?   Hi, The data types allowed in a table are as follows-ADS_TO_REPLACE_1 binary Bigint bit Char datetime
java parsing of data types
java parsing of data types  Why its not works? char ch; String s=* ch=Character.parseChar(s) program: char op; DataInputStream dis=new DataInputStream(System.in); System.out.print("Enter operator (+,-,*,/,%): "); op
demonstrating understanding of data types
demonstrating understanding of data types  Design and implement a Java program that will gather a userā??s first name, middle initial, lastname, age in years, and 3 lucky numbers. The program should output the following based
Object with different data types
Object with different data types  Hello, I need to build a "patient" object that can contain String "name", String "ID", double "weight" and Date "birthDate". Then that object is referenced to the linked list. I know how to use
PHP Data Types
Data Types in PHP:  In programming language there are two types of data: atomic data and composite data, atomic data are those which can not broken further and composite data are just the opposite and it can be broken further
inserting same data to different tables in oracle
inserting same data to different tables in oracle  Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can
inserting same data to different tables in oracle
inserting same data to different tables in oracle  Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can
inserting same data to different tables in oracle
inserting same data to different tables in oracle  Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can
inserting same data to different tables in oracle
inserting same data to different tables in oracle  Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can
inserting same data to different tables in oracle
inserting same data to different tables in oracle  Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can
inserting same data to different tables in oracle
inserting same data to different tables in oracle  Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can
Select tag to fetch data from oracle database
Select tag to fetch data from oracle database  I created a select box having more than one menus in the select box such as regnno, address and name... oracle database.Similarly when address will be selected by the user from
ModuleNotFoundError: No module named 'data-science-types'
ModuleNotFoundError: No module named 'data-science-types'  Hi, My... named 'data-science-types' How to remove the ModuleNotFoundError: No module named 'data-science-types' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'algebraic-data-types'
ModuleNotFoundError: No module named 'algebraic-data-types'  Hi...: No module named 'algebraic-data-types' How to remove the ModuleNotFoundError: No module named 'algebraic-data-types' error? Thanks   Hi
ModuleNotFoundError: No module named 'data-science-types'
ModuleNotFoundError: No module named 'data-science-types'  Hi, My... named 'data-science-types' How to remove the ModuleNotFoundError: No module named 'data-science-types' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'algebraic-data-types'
ModuleNotFoundError: No module named 'algebraic-data-types'  Hi...: No module named 'algebraic-data-types' How to remove the ModuleNotFoundError: No module named 'algebraic-data-types' error? Thanks   Hi
ModuleNotFoundError: No module named 'data-science-types'
ModuleNotFoundError: No module named 'data-science-types'  Hi, My... named 'data-science-types' How to remove the ModuleNotFoundError: No module named 'data-science-types' error? Thanks   Hi, In your
Primitive Data Types
Primitive Data Types In java, all the variables needs to be declared first... below : Java Data Types.... The value assigned to a variable determines its data type, on which the legal
Oracle Tutorial
is stored as tablespaces. It is flexible and cost-effective. In Oracle data... the resource pools as needed. Oracle Database has two types of structure: Logical... v8 Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp   data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp with script of data base plz help me
Reference Data Types
Reference Data Types      ...;Reference Data Types Lets have a discussion about Reference Data Types in brief ADS_TO_REPLACE_1 In Java a reference data type
Convert the excel sheet data into oracle table through java or jsp
Convert the excel sheet data into oracle table through java or jsp  Hi Friends, Let me help this issue i am phasing Convert the excel sheet data into oracle table through java or jsp
insert excel value in to oracle data base
insert excel value in to oracle data base  Hi All I am using this code for saving excel value to oracle database table. code is working properly... then how excel data will mapp to oracle database table. My project requrement
Python variables and data types
Python Tutorials: Learning variables and data types in Python with examples The variables and data types are essential topics in Python programming language. Programmers should learn to use various data types in Python Programming
Python variables and data types
Python Tutorials: Learning variables and data types in Python with examples The variables and data types are essential topics in Python programming language. Programmers should learn to use various data types in Python Programming

Ads