What is the purpose of using pl/sql?



What is the purpose of using pl/sql?..

Answer / Manish Singh

The purpose of using PL/SQL is to create, manipulate, and control Oracle database objects. It allows for more complex logic than SQL alone and can be used for procedural programming, data validation, error handling, and trigger creation.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How many times can we commit in a loop?

1 Answers  


how can we know the number of days between two given dates using mysql? : Sql dba

1 Answers  


When can we use the where clause and the having clause?

1 Answers  


What is full join in sql?

1 Answers  


Explain aggregate functions are available there in sql?

1 Answers  


In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  


What are different types of sql commands?

1 Answers  


What are sql constraints?

1 Answers  


How do I view a view in sql?

1 Answers  


What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,


what is the syntax used for partition in tsql? : Transact sql

1 Answers  


What are the disadvantages of not performing database normalization?

1 Answers  


Categories