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 |
Explain what is a column in a table?
How do you assign Construct the where clause without concatenating Field,value pairs?
How to display Row Number with Records in Oracle SQL Plus?
What is a pragma statement?
Delete the emps whose salaries are lowest sals of their own dept.
Which one is better subquery or joins?
what is the boundary line in varrays?
What is set transaction?
What is the basic structure of an sql?
What are the different types of functions in sql?
. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,