What is the difference between sql/pl-sql/embeded sql?
Answers were Sorted based on User's Feedback
Answer / madhuri
SQL is a structured query language used for various
operations such as retrieval,manipulation of data using
DML,DDL statements.
PL/SQL is programming language used to write various sql
statements together.Advantage of pl/sql over sql is,you can
write many sql statements within a pl/sql block.One more
advantage is subprogramming like procedures and functions.
We can write cursors for fetching number of records at a time.
And also packages and triggers.
Embedded sql are those statements which are written in host
programs like pro*c,java etc.
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / siragam manjunath reddy
Both sql and pl/sql are languages used to acess data with in
oracle data base....sql writtens querys by using ddl,dml,dcl
etc...where plsql uses cursors,triggers,procedures etc..
In sql querys process at a time where as in plsql it done
step by step or recoed by record ...
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / swapna
SQL is Structured Query Language used for DDL,DML.
PL/SQL is used for Cursors and Triggers .
Embeded SQL is used to embed SQL statements in
C,Cobol,Pascal,Foxpro like languages.
Embedded SQL - SQL statements are invoked from a host
environment like C/C++, Java or any other programming
languages.
Is This Answer Correct ? | 5 Yes | 6 No |
What is sql profiling in oracle?
What is union and union all keyword in sql and what are their differences?
What is auto increment?
how to use 'mysql' to run sql statements? : Sql dba
What is the difference between clustered and non-clustered index in sql?
how do you count the duplicate records in a table
who introduced sql?
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
Can two tables have same primary key?
What is database sql?
Is sql database free?
how to use in conditions? : Sql dba