what is pragma?
Answers were Sorted based on User's Feedback
Answer / 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 |
Which is better Oracle or MS SQL? Why?
What privilege is needed for a user to insert rows to tables in another schema?
How to display row numbers with the records?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
how to handle exceptions in post production
What is SQL access advisor in Oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to use existing values in update statements using oracle?
How to connect asp pages to oracle servers?
Describe varray?
what is view?