What is PL/SQL ?

Answer Posted / hr@tgksolutions.com

PL/SQL refers to Procedural Language/Structured Query Language. It is a programming language extension of SQL that allows you to write procedural code, such as loops, conditional statements, exception handling, and SQL statements. PL/SQL is mainly used for developing database applications and stored procedures within Oracle Database.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a cursor variable?

816


How will you differentiate between varchar & varchar2?

827


Explain what are the characteristics of data files?

842


What is sequence?

843


How to store only time; not date and time?

760


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1834


Explain what are the uses of rollback segment?

798


What is oracle used for?

772


Explain oracle insert into command?

868


What is the difference between substr & instr functions?

866


Why does Oracle not permit the use of PCTUSED with indexes?

2192


How to login to the server without an instance?

848


Explain the use of Merge statement in oracle 11g

812


What is proxy method?

756


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2043