| |
GeekInterview.com > Interview Questions > Oracle > PL/SQL
| Print | |
| Question: What is PL/SQL ?
Answer: PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. |
| July 07, 2007 05:33:56 |
#4 |
| rajesh |
Member Since: Visitor Total Comments: N/A |
What is PL/SQL ? |
PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database.
New Term - If you have worked with relational databases in the past, you are no doubt familiar with SQL, which stands for Structured Query Language. SQL itself is a powerful declarative language. It is declarative in the sense that you describe the results that you want but not how they are obtained. This is good because you can insulate an application from the specifics of how the data is physically stored. A competent SQL programmer can also push a great deal of processing work back to the server level through the creative use of SQL. |
| |
Back To Question | |