What is a pragma statement?



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

Post New Answer

More SQL PLSQL Interview Questions

What are the built in functions of sql?

1 Answers  


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

1 Answers  


How does left join work in sql?

1 Answers  


Which constraints we can use while creating database in sql?

1 Answers  


What is the usage of sql functions?

1 Answers  


Why is pl sql used?

1 Answers  


Can ddl statements be used in pl/sql?

1 Answers  


How to display the current date in sql?

1 Answers  


Why is the cursor important?

1 Answers  


What does seeding a database mean?

1 Answers  


what is the difference between clustered and non clustered index in sql? : Sql dba

1 Answers  


What is clustered index sql?

1 Answers  


Categories