how to check errors from plsql package not by log file not by "show err"from sql * plus provided concurrent program name

prakash

• Jun 8th, 2015

Using dbms_utility.format_error_mask function will be used to get errors from that package.

Karthik Sai

• Feb 2nd, 2015

Using exception / dbms output are the best and easier methods

Answer Question  Select Best Answer

SRI RAM REDDY

• Nov 14th, 2015

Truncate is DDL command, not a DML command When we issue Truncate on a database table, the records are deleted from the table, and structure remains same. Once we issue truncate on a table, the record...

Akshatha

 Profile Answers by Akshatha Questions by Akshatha

• Dec 25th, 2014

Truncate is DDL. Auto commits the transaction. Also, truncating a table can reset the high water mark if REUSE storage clause is not used.

Answer Question  Select Best Answer