datatype - LOV
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: datatype - LOV

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Location
    japan
    Posts
    2

    Question

    I am new to Oracle datatype, I need some immediate help..

    Can anyone please guide me how to use LOV oracle datatype
    and what it is.?

    Whether NVARCHAR() is better than VARCHAR2()?
    Does NVARCHAR() supports localization(different languages) and how is it?

    For long text fields should i keep CLOB or TXT as datatype.

    Thanks in advance.

    Regards,
    Komal.

  2. #2
    Join Date
    Aug 2001
    Posts
    5
    Hi,
    1)Unlike a normal SQL*Forms query, which performs buffering, a List of Values (LOV) will read all of the records queried from the database before displaying them.

    LOV's can be replaced with separate Forms to reduce the number of records transmitted from the database and to save huge amounts of memory.

    2) Convert the data into UTF-8 format. UTF-8 is variable-width multi-byte and is a valid charset for all cases.

    Hope this helps you.

    Regards,
    Senthil Babu J
    SlashSupport

  3. #3
    Join Date
    Sep 2001
    Location
    japan
    Posts
    2
    hello senthil babu,

    thanks for ur reply..
    but i could not understand this.. well my question is.


    Is there datatype called LOV like VARCHAR()?

    example:

    if i want to store different values for one item like
    in fruit category we can have : apple mango, et.

    Standard approach which I know is:

    Fieldname datatype values
    ---------------------------------------------------------------
    lov_id number 1 1
    lov_desc varchar2() Fruits, Fruits
    lov_value number 1.1 1.2
    lov_name varhar2() apple mango

    Can i specify something as LOV and it holds the possible values of fruits?

    thanks and regards,
    Komal.

    [Edited by komalvora on 09-10-2001 at 02:35 AM]

  4. #4
    Join Date
    Aug 2001
    Posts
    5
    Hi,
    I dont think, is there any LOV which it holds the possible values of fruits.

    Regards,
    Senthil Babu J
    SlashSupport.

  5. #5
    Join Date
    Sep 2001
    Posts
    2
    Do you know how to create LOVs for views?

Posting Permissions

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



Click Here to Expand Forum to Full Width