Compare SQL and PL/SQL.
Answers were Sorted based on User's Feedback
Answer / nashiinformaticssolutions
SQL is a domain-specific language to manage and manipulate relational databases. It primarily deals with querying, inserting, updating, and deleting data in a database. On the other hand, PL/SQL is a procedural language that extends SQL by adding programming constructs like variables, loops, and exception handling. PL/SQL is used for writing stored procedures, functions, and triggers, allowing for more complex and reusable database logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / glibwaresoftsolutions
SQL is a domain-specific language to manage and manipulate relational databases. It primarily deals with querying, inserting, updating, and deleting data in a database. On the other hand, PL/SQL is a procedural language that extends SQL by adding programming constructs like variables, loops, and exception handling. PL/SQL is used for writing stored procedures, functions, and triggers, allowing for more complex and reusable database logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
SQL is a domain-specific language to manage and manipulate relational databases. It primarily deals with querying, inserting, updating, and deleting data in a database. On the other hand, PL/SQL is a procedural language that extends SQL by adding programming constructs like variables, loops, and exception handling. PL/SQL is used for writing stored procedures, functions, and triggers, allowing for more complex and reusable database logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the non-standard sql commands supported by 'mysql'? : Sql dba
how to get @@error and @@rowcount at the same time? : Sql dba
What are few of the schema objects that are created using PL/SQL?
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
Why select is used in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What are character functions in sql?
What are the popular database management systems in the it industry?
What is the default isolation level in sql server? : Transact sql
Does truncate need commit?
what are integrity rules?
What packages are available to pl/sql developers?
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)