What is a pragma statement?
Answer / 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 |
What are the built in functions of sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How does left join work in sql?
Which constraints we can use while creating database in sql?
What is the usage of sql functions?
Why is pl sql used?
Can ddl statements be used in pl/sql?
How to display the current date in sql?
Why is the cursor important?
What does seeding a database mean?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is clustered index sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)