Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between sql/pl-sql/embeded sql?
- 3 Answers
- 12556 Views
- I also Faced
- E-Mail Answers
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 a scheduled jobs or what is a scheduled tasks? : Sql dba
Where the integrity constrints are stored in Data Dictionary?
What are the two characteristics of a primary key?
How many levels can subqueries be nested in a FROM clause?
PL/SQL allocates memory for the variable's at runtime or at compile time
Is it possible to create the following trigger: before or after update trigger for each row?
how to enter numeric values as hex numbers? : Sql dba
What is asqueryable?
What is recursive join in sql?
What is not null in sql?
Can you have more than one key in a database?
how will you find out the last three records in a table with n no of records and delete them
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
