GeekInterview.com
Series: Subject: Topic:
Question: 284 of 284

 What is PL/SQL ?

PL/SQL  is  a  procedural  language  that  has  both  interactive  SQL  and procedural  programming  language constructs such as iteration, conditional branching.
Asked by: Interview Candidate | Asked on: Sep 9th, 2004
Showing Answers 1 - 9 of 9 Answers
tm1966_muthu

Answered On : Feb 17th, 2006

View all answers by tm1966_muthu

PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL's language syntax, structure and datatypes are similar to that of ADA. The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.

  
Login to rate this answer.
Nagendra

Answered On : Mar 3rd, 2006

Hi Sir,

1.What is PL/SQL ?

Answer :

                PL/SQL is  Procedural Language extension to SQL. PL/SQL's language syntax, structure and datatypes are similar to that of ADA. The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.

  
Login to rate this answer.

hii
       pl/sql is procedural language extenction to structure query language.

  
Login to rate this answer.
rajesh

Answered On : Jul 23rd, 2007



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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
Yestha Bapna

Answered On : Aug 14th, 2007

PL SQL is a block structured programming language. It combines data manipulation & data processing power. It supports all SQL data types. Also has its own data types i,e BOOLEAN,BINARY INTEGER

  
Login to rate this answer.
narender sharma

Answered On : Oct 30th, 2007

Pl/Sql is a procedural extension to sql with design feature of programming language.

  
Login to rate this answer.
narender1908

Answered On : Oct 30th, 2007

View all answers by narender1908

PL/SQL is procedural extension to SQL with design feature of programming language.

  
Login to rate this answer.
g_sidhu

Answered On : Feb 16th, 2008

PL/SQL is the procedural extension to SQL with design features of programming languages. Data manipulation and query statements of SQL are included within procedural units of code. PL/SQL offers modern software engineering features such as data encapsulation, exception handling, information hiding, object orientation.

  
Login to rate this answer.
surya72446

Answered On : Sep 30th, 2009

View all answers by surya72446

PL/SQL stands for procedural languages extensions to SQL and it's theme is to hold a bunch of SQL statements as a single function and return a single output.
PL/SQL is advantageous compared to other programming languages as it is a Oracle proprietary and does not require any external interfaces for the database connectivity.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.