Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    3

    Unanswered: oracle data type

    WHICH ARE NOT VALID ORACLE DATA TYPE ?

    CHAR
    INT
    TIMESTAMP
    NUMBER
    VARCHAR2

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296

    Re: oracle data type

    Originally posted by ashraf ali
    WHICH ARE NOT VALID ORACLE DATA TYPE ?

    CHAR
    INT
    TIMESTAMP
    NUMBER
    VARCHAR2
    never used timestamp before.
    However, it works.
    Actually they all work except varchar2 because you need to specify precision.
    PHP Code:
    19:00:39 kod:Prod_copycreate table test (testing timestamp);

    Table created.

    19:42:55 kod:Prod_copycreate table test (testing int);

    Table created.

    19:43:50 kod:Prod_copycreate table test (testing varchar2)
    19:44:11   2  ;
    create table test (testing varchar2)
                                       *
    ERROR at line 1:
    ORA-00906missing left parenthesis


    Elapsed
    00:00:00.00
    19
    :44:12 kod:Prod_copycreate table test (testing number);

    Table created
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •