difference of sql sql plus and pl sql n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Difference of SQL, SQL*Plus and PL/SQL PowerPoint Presentation
Download Presentation
Difference of SQL, SQL*Plus and PL/SQL

Loading in 2 Seconds...

play fullscreen
1 / 3

Difference of SQL, SQL*Plus and PL/SQL - PowerPoint PPT Presentation


  • 2 Views
  • Uploaded on

There are a few products with the letters \"SQL\" in the title, and these three, SQL*Plus, SQL, and PL/SQL, are frequently utilized together. Along these it\'s easy to become difficult as to which product is doing the work is being finished

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Difference of SQL, SQL*Plus and PL/SQL' - satishkartan


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
difference of sql sql plus and pl sql

Difference of SQL, SQL*Plus and

PL/SQL

There are a few products with the letters "SQL" in the title, and these

three, SQL*Plus, SQL, and PL/SQL, are frequently utilized together.

Along these it's easy to become difficult as to which product is doing the

work is being finished. This segment explained by Satish Kartan quickly

portrays each of these three products.

SQL

It remains for Structured Query Language. This has turned into the

lingua franca of database get to languages. It has been adopted by the

International Standards Organization (ISO) and has likewise been

embraced by the American National Standards Institute (ANSI). When

you code proclamations, for example, SELECT, INSERT, UPDATE, and

DELETE, it is the language you are utilizing. It is an explanatory

language and is constantly executed on the database server. Regularly

you will yourself coding and statement in a development tool, for

example, Power Builder or Visual Basic, yet at runtime those statements

are sent to the server for execution.

PL SQL

It is Oracle's Procedural Language extension to SQL. It, as well, normally

running on the database server, yet some Oracle products, for example,

Developer/2000 additionally contains a PL SQL engine that resides on

the customer. Along these lines, you can run your code on either the

client or the server relying upon which is more proper for the task at

hand. Not at all like these are procedural, not explanatory. This implies

your code determines precisely how things complete. As in be that as it

may you require some approach to send your code

may, you require some approach to send your code up to the server for

execution. It likewise empowers you to implant statement inside its

procedural code. This tight knit connection between these three types of

SQL is the reason for a portion of the confusion between the products.

Most of the institutes are giving PL SQL online training.

SQL*Plus

It is an intuitive program that enables you to sort in and execute

statements. It likewise empowers you to sort in PL/SQL code and send it

to the server to be executed. This is a standout amongst the most widely

recognized front finishes used to create and make put away strategies

and functions.

What happens when you run and sort in a statement? Where does the

preparing occur? What precisely does SQL*Plus do and what does the

database do? In the event that you are in a Windows situation and you

have a database server some place on the system.

PL/SQL is executed in much a similar way. Type a PL/SQL obstruct into

SQL*Plus, and it is transmitted to the database server for execution. In

the event that there is any statement in the code, they are sent to the

server's engine for execution, and the outcomes are returned back to the

program.

The vital thing is that SQL*Plus does not execute your questions. This is

additionally does not execute your code. It basically fills in as your

window into the Oracle database, which is the place the real action

makes put.

satish kartan is a webmaster who is skilled

Satish Kartan is a webmaster who is skilled in writing on data recovery

topics as he has an in-depth knowledge on the very topic, data recovery.

Kartan has been working with SQL Server for the past 20 years.

To read more you can visit Satish Kartan's blog where he has shared

much more!

For more reading, please visit here: http://satishkartan.kinja.com/