Answer Posted / Indal Babu
A pragma statement in PL/SQL is a directive used to provide additional information or instructions for the PL/SQL compiler. Commonly used pragmas include pragma AUTONOMOUS_TRANSACTION (to create an autonomous transaction), pragma RESTRICT_REFERENCES (to enforce referential integrity), and pragma UNDOTAB (to control underscore substitution in identifiers).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is your daily office routine?
Can delete statement be rollbacked?
Does group by remove duplicates?
Is primary key always clustered index?
how to escape special characters in sql statements? : Sql dba
Do we need to rebuild index after truncate?
Can we rollback truncate?
what are aggregate and scalar functions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is schema? : Sql dba
What is the current version of postgresql?
what are all the common sql function? : Sql dba
How do I remove duplicates in two columns?
how many tables will create when we create table, what are they? : Sql dba
how to start mysql server? : Sql dba
