What is pl/sql and what is it used for?

Answer Posted / pavan_1981

PL/SQL is Oracle's Procedural Language extension to SQL.
PL/SQL's language syntax, structure and data types are
similar to that of ADA. The PL/SQL language includes object
oriented programming techniques such as encapsulation,
function overloading, information hiding (all but
inheritance). PL/SQL is commonly used to write data-centric
programs to manipulate data in an Oracle database

Is This Answer Correct ?    16 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rename a column in the output of sql query?

543


Which tcp/ip port does sql server run?

538


What steps server process has to take to execute an update statement?

511


Is it possible to pass parameters to triggers?

575


What are aggregate functions in sql?

631






What are stored procedures in mysql?

566


Does mysql_real_escape_string prevent sql injection?

539


Can triggers stop a dml statement from executing on a table?

618


Which is faster truncate or drop?

562


How can you create an empty table from an existing table?

596


What is pl sql script?

564


Which type of cursor is used to execute the dml statement?

534


What is a file delimiter?

556


What are variables in pl sql?

569


How can you fetch common records from two tables?

591