what is the difrence between sql and pl/sql
Answers were Sorted based on User's Feedback
Answer / anuj maheshwari
sql -> structure query language.
pl/sql -> procedure language in structure query language.
this is the main difference..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tonmoy bhattacharya
SQL Enter, Edit, Store & Retrieve by single command or
statement where as PL/SQL process all SQL statements one at
a time. With PL/SQL, an entire block of statements process
in a single command line.
SQL in a strucutred query language; where pl/sql is
procedures,function,variable,method all are present
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raj kumar soni
SQL is Structured Query Language which is used for accessing
some desired information from the table.
While PL/SQL is Procedural Language/Structure Query Language
which is used for making programs which is having predefined
structure.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mayank singh
Differce B/W Pl/sql & sql is that pl/sql is used gor
Logical databese Creation. it is used in backend . It is
used for Programming.
sql is Used for front end & Used for Physical data base
creation maintain tabes & rows.
| Is This Answer Correct ? | 1 Yes | 7 No |
Answer / rsr
Actually,
All those above answers are wrong..Because the question is
itself wrong as it has a spelling mistake for "difference"
and its displayed as "difrence".People like me only can
find this error(Bug) as because i wear Specs.
For more exact answers please contact : aar.sundar@gmail.com
| Is This Answer Correct ? | 2 Yes | 13 No |
Answer / karthik krishnan
Similarly i have many answers for the critical and vertical
questions.
Even you can reach me by mail-id.
karthik.krishnagiri@gmail.com
| Is This Answer Correct ? | 3 Yes | 21 No |
Answer / mr.kiruba sankar
Hello!!
If you people dont know the answer please atleast learn
from my post.
Ans : The main diffrence is ,SQL is only for team members
but when the project lead uses it,then its named as
ProjectLead SQL (shortly pl/sql)
So i think you people understood my technical knowledge, So
for any answers contact me(Incoming free).
| Is This Answer Correct ? | 2 Yes | 21 No |
Answer / karthik krishnan
Usually we will used to mention pl/sql, so there are three
characters differing. And considering the special character
is mandatory.
| Is This Answer Correct ? | 2 Yes | 31 No |
Answer / sudhakar shanmugam
No.The above is not a correct one.
The appropriate answer is there is only 2 letters
extra "pl" and one special charcter "/" extra.
| Is This Answer Correct ? | 5 Yes | 53 No |
Can not connect to mysql server 10060?
What is full text indexing in mysql?
Does mysql automatically index foreign keys?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What are the difference between now and current_date in mysql?
What is difference between mysql_connect and mysql_pconnect?
SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details
What is mysql server used for?
What is current version of mysql?
How do we delete a row in a table?
What is the difference between truncate and delete?
What are slow queries?
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)