datatype - LOV

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.

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

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]

Hi,
I dont think, is there any LOV which it holds the possible values of fruits.

Regards,
Senthil Babu J
SlashSupport.

Do you know how to create LOVs for views?