{"id":350,"date":"2020-01-24T11:58:22","date_gmt":"2020-01-24T11:58:22","guid":{"rendered":"http:\/\/lotusithub.com\/blog\/?p=350"},"modified":"2020-01-24T11:58:22","modified_gmt":"2020-01-24T11:58:22","slug":"difference-between-sql-and-plsql","status":"publish","type":"post","link":"https:\/\/lotusithub.com\/blog\/difference-between-sql-and-plsql\/","title":{"rendered":"Difference Between SQL and PLSQL:"},"content":{"rendered":"

The following are the important differences between SQL and PL\/SQL.<\/span><\/h3>\n

\"Difference<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Sr. No.<\/b><\/td>\nKey<\/b><\/td>\nSQL<\/b><\/td>\nPL\/SQL<\/b><\/td>\n<\/tr>\n
1<\/span><\/td>\nDefinition<\/span><\/td>\nSQL, is Structural Query Language for database.<\/span><\/td>\nPL\/SQL is a programming language using SQL for a database.<\/span><\/td>\n<\/tr>\n
2<\/span><\/td>\nVariables<\/span><\/td>\nSQL has no variables.<\/span><\/td>\nPL\/SQL has variables, data types etc.<\/span><\/td>\n<\/tr>\n
3<\/span><\/td>\nVariable declaration<\/span><\/td>\nColumn declaration<\/span><\/td>\nA int:=100;<\/span><\/p>\n

B varcharchar2(20):=\u2019Lotus it hub\u2019;<\/span><\/td>\n<\/tr>\n

4<\/span><\/td>\nControl Structures<\/span><\/td>\nSQL has no FOR loop, if control and similar structures.<\/span><\/td>\nPL\/SQL has FOR loop, while loop, if controls and other similar structures.<\/span><\/td>\n<\/tr>\n
5<\/span><\/td>\nBasic c<\/span><\/td>\nSql doesn\u2019t require to know c language.<\/span><\/td>\nPlsql require to know c language.<\/span><\/td>\n<\/tr>\n
6<\/span><\/td>\nOperations<\/span><\/td>\nSQL can execute a single operation at a time.<\/span><\/td>\nPL\/SQL can perform multiple operations at a time.<\/span><\/td>\n<\/tr>\n
7<\/span><\/td>\nLanguage Type<\/span><\/td>\nSQL is a declarative language.<\/span><\/td>\nPL\/SQL is a procedural language.<\/span><\/td>\n<\/tr>\n
8<\/span><\/td>\nEmbedded<\/span><\/td>\nSQL can be embedded in a PL\/SQL block.<\/span><\/td>\nPL\/SQL can also be embedded in SQL code.<\/span><\/td>\n<\/tr>\n
9<\/span><\/td>\nInteraction<\/span><\/td>\nSQL directly interacts with database server.<\/span><\/td>\nPL\/SQL does not directly interact with database server.<\/span><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
10<\/span><\/td>\nFetch\u00a0<\/span><\/td>\nSelect * from table_name<\/span><\/td>\nDeclare<\/span><\/p>\n

Begin<\/span><\/p>\n

Dbms_output.put_line(\u2018Lotus IT Hub!!\u2019);<\/span><\/p>\n

End;<\/span><\/p>\n

\/<\/span><\/td>\n<\/tr>\n

8<\/span><\/td>\nObjective<\/span><\/td>\nSQL is used to write queries, create and execute DDL and DML statements.<\/span><\/td>\nPL\/SQL is used to write program blocks, functions, procedures, triggers and packages.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

ENROLL NOW<\/span><\/a><\/p>\n

PL\/SQL Data Types<\/b><\/h2>\n\n\n\n\n\n\n\n\n\n\n\n
Data Type<\/b><\/td>\nDescription<\/b><\/td>\nSize<\/b><\/td>\n<\/tr>\n
BFILE<\/span><\/td>\nUsed to store large binary objects in operating system files outside the database.<\/span><\/td>\nSystem-dependent. Cannot exceed 4 gigabytes (GB).<\/span><\/td>\n<\/tr>\n
BLOB<\/span><\/td>\nUsed to store large binary objects in the database.<\/span><\/td>\n8 to 128 terabytes (TB)<\/span><\/td>\n<\/tr>\n
CLOB<\/span><\/td>\nUsed to store large blocks of character data in the database.<\/span><\/td>\n8 to 128 TB<\/span><\/td>\n<\/tr>\n
NCLOB<\/span><\/td>\nUsed to store large blocks of NCHAR data in the database.<\/span><\/td>\n8 to 128 TB<\/span><\/td>\n<\/tr>\n
int<\/span><\/td>\n-2,147,483,648<\/span><\/td>\n2,147,483,647<\/span><\/td>\n<\/tr>\n
datetime<\/span><\/td>\nJan 1, 1753<\/span><\/td>\nDec 31, 9999<\/span><\/td>\n<\/tr>\n
float<\/span><\/td>\n-1.79E + 308<\/span><\/td>\n1.79E + 308<\/span><\/td>\n<\/tr>\n
real<\/span><\/td>\n-3.40E + 38<\/span><\/td>\n3.40E + 38<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Request For Call Back<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The following are the important differences between SQL and PL\/SQL.   Sr. No. Key SQL…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[77,118,119,120],"class_list":["post-350","post","type-post","status-publish","format-standard","hentry","category-sql-classes","tag-differences-between-sql-and-pl-sql","tag-pl-sql","tag-plsql","tag-plsql-classes"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/posts\/350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/comments?post=350"}],"version-history":[{"count":0,"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/posts\/350\/revisions"}],"wp:attachment":[{"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/media?parent=350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/categories?post=350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lotusithub.com\/blog\/wp-json\/wp\/v2\/tags?post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}