Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQL and PLSQL
- 7 Answers
- 11186 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil bisht
SQL is the only language through which you create or modify
data and structures in Oracle. Although other tools will
connect with the database, they all use SQL to read and
modify data.
Oracle's PL/SQL is a programming lanuguage that extends SQL
to include procedural elements, such as loops and whatnot.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / khan tauseef
SQL is structure Query Language whereas PL/SQL is Procedural
Language Structure Query Language.
SQL does not have Stored Procedures/Stored Functions whereas
PL\SQL has.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / g.sivanagaraju
SQL is a standard structured query language for all the Relational Databases using SQL we can INSERT,UPDATE,DELETE,RETRIEVE and MODIFY the structure of the database.
PLSQL is procedural level extension to the SQL. PLSQL uses Data Manipulation power of SQL and procedural power of some other languages.
PGA gets created by ORACLE SERVER while working in PLSQL environment unlike SQL, SGA.
We can perform complex level validations using PLSQL unlike SQL.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nashiinformaticssolutions
• SQL (Structured Query Language):
o Used to interact with databases (e.g., querying, inserting, updating data).
o Declarative in nature.
• PL/SQL (Procedural Language/SQL):
o Procedural extension of SQL in Oracle.
o Supports loops, conditions, and error handling.
o Used for creating functions, triggers, and stored procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / glibwaresoftsolutions
• SQL (Structured Query Language):
o Used to interact with databases (e.g., querying, inserting, updating data).
o Declarative in nature.
• PL/SQL (Procedural Language/SQL):
o Procedural extension of SQL in Oracle.
o Supports loops, conditions, and error handling.
o Used for creating functions, triggers, and stored procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
• SQL (Structured Query Language):
o Used to interact with databases (e.g., querying, inserting, updating data).
o Declarative in nature.
• PL/SQL (Procedural Language/SQL):
o Procedural extension of SQL in Oracle.
o Supports loops, conditions, and error handling.
o Used for creating functions, triggers, and stored procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Collation Sensitivity ? What are the various type ?
how to increment dates by 1 in mysql? : Sql dba
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is minus?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How long it takes to learn pl sql?
Which are the different character-manipulation functions in sql?
Can a foreign key be a duplicate?
How subquery works in sql?
What does rownum mean in sql?
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
Define commit?
-
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)
