How many columns you can create in table from this type "long raw"?

krishnaveni_g

 Profile Answers by krishnaveni_g Questions by krishnaveni_g

• Jul 17th, 2008

We can use only one long column in a table

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Jun 25th, 2008

Only single column is allowed per a table of data type LONG or LONG RAW

Answer Question  Select Best Answer

How to find the max value in a Sequence?

mstreete

 Profile Answers by mstreete Questions by mstreete

• Sep 30th, 2008

If you don't own the sequence, you may look at all_sequences, which shows sequences in other schemas that you have access to:select max_valuefrom sys.all_sequenceswhere sequence_owner = '&sequence_owner' and sequence_name = '&sequence_name'

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 30th, 2008

We can get the MAX value of a sequence by using the data dictionary view 'USER_SEQUENCES' .i.e.  SELECT MAX_VALUE FROM USER_SEQUENCES       WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE'

Answer Question  Select Best Answer