adspace


What is the difference between pl and sql?

Answer Posted / Akshay Kumar

SQL (Structured Query Language) is a standard language for managing and manipulating databases, while PL/SQL (Procedural Language SQL) is a procedural extension of SQL provided by Oracle Corporation to embed SQL commands within PL/SQL blocks. PL/SQL allows the creation of stored procedures, functions, triggers, packages, and other program units that can be used to encapsulate logic and improve database performance.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to start mysql server? : Sql dba

1279


what is bcp? When does it used? : Sql dba

1065


what are all the common sql function? : Sql dba

1141


what is collation? : Sql dba

1242


Do we need to rebuild index after truncate?

1154


what is dbms? : Sql dba

1070


What is the best sql course?

1064


What is your daily office routine?

2353


If a cursor is open, how can we find in a pl/sql block?

1252


Is primary key clustered index?

1028


Can we use distinct and group by together?

1147


what are the advantages of sql ? : Sql dba

1154


Is primary key always clustered index?

1101


how to escape special characters in sql statements? : Sql dba

1124


what are aggregate and scalar functions? : Sql dba

1142