Answer Posted / svj
PRAGMA (also called pseudo instructions) is the keyword
that signifies that the statement is a compiler directive,
which is not processed when PL/SQL block is executed.
Rather,it directs the PL/SQL compiler to interpret all
occurrences of the exception name within the block as the
associated Oracle server error number.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is MTTR advisor in Oracle?
what are the advantages of running a database in archive log mode?
How to delete all rows a table in oracle?
How a tablespace is related to data files?
How to drop an index in oracle?
Explain oracle instance.
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
State some uses of redo log files?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to retrieve values from data fields in record variables?
How to rename a tablespace in oracle?
How to increment dates by 1 in oracle?
What is user managed backup in Oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?