Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    London, UK
    Posts
    39

    Question Unanswered: Datatypes: Numbers, Enumerations and Boolean

    Hi,

    It's been some time since I've worked with Oracle databases and I've forgotten a few of the basics. Here's just a few simple questions;

    1. Does Oracle support the INT datatype?

    2. Does Oracle provide an Enumeration datatype?

    3. Does Oracle support the BOOLEAN datatype? (if not, how could I implement this?)

    4. Are parameters for the datatypes NUMBER and VARCHAR2 required? (and if not, what are the defaults?)



    Thanks all

    Goran (GoMo)
    Last edited by GoMo; 11-15-03 at 09:49.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://tahiti.oracle.com contains all Oracle's documentation sets.
    Go RTFM to find answers to your questions.

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    1. There's no INT datatype in SQL. But the same functionality is
    obtained through NUMBER Datatype. PL\SQL supports INT Datatype.
    Again this is a subset of the NUMBER datatype that is used for
    variable declaration in PL/SQL.

    2. BOOLEAN datatpe is not supported in SQL, But its suported in PL\SQL.

    3. The data size can be passed as the parameter to NUMBER &
    VARCHAR2 Datatypes. For Number, the precision values can also be
    passed as parameter. (E-x) : NUMBER(5,2) means , its a 5 digit
    number with 3 digits before decimal point & 2 digits after Decimal
    Point.
    SATHISH .

  4. #4
    Join Date
    Nov 2003
    Location
    London, UK
    Posts
    39
    Thanks for your help guys, but I'm still having trouble finding out about Enumeration in Oracle .... any insight on that???

  5. #5
    Join Date
    Jan 2004
    Posts
    5
    Hi again
    Thanx for all, i`ve tested sequinece and trigger, but there has appeared another problem:
    it automatically gives ID numbers, but it ordering by his own ROWID, that is every id`s ROWID is like this:
    [i got it during deleting rows from down to up one by one]
    DELETE FROM "AHAD"."PROGS"
    WHERE rowid = 'AAAHb3AABAAAMjqAAC' / id=1
    DELETE FROM "AHAD"."PROGS"
    WHERE rowid = 'AAAHb3AABAAAMjqAAB' / id=3
    DELETE FROM "AHAD"."PROGS"
    WHERE rowid = 'AAAHb3AABAAAMjqAAA' / id=2

    => ID1='AAAHb3AABAAAMjqAAC'
    => ID2='AAAHb3AABAAAMjqAAA'
    => ID3='AAAHb3AABAAAMjqAAB'
    but it ordered by its' rowid value (look above)

    What to do? I`ve tested to give ID column UNIQUE and PRIMARY values, but : same problem

    Thanx before
    (if it was Hard understandeble, sorry before)

Posting Permissions

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