How can we generate debugging output from PL/SQL?

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• Feb 24th, 2009

Use "SHOW ERRORS" command.Regards,Karthik

KD09714

 Profile Answers by KD09714 Questions by KD09714

• Jun 28th, 2008

Stshekhar is right, oracle supplied package DBMS_OUTPUT with procedures PUT, PUT_LINE, NEW_LINE etc in case of debugging pl/sql

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

How to skip columns while loading data with SQLLDR

lokeshRao

 Profile Answers by lokeshRao Questions by lokeshRao

• Jun 23rd, 2008

Specify Filler Load datatruncate into table empfields treminated by'|'(field1,field2 filler,field 3)

Answer Question  Select Best Answer