What is the difference between pl and sql?
Answer / 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 |
what is collation? : Sql dba
Does a primary key have to be a number?
What is a database link?
Explain what is a subquery ?
What is rule base and cost base optimizer?
define join and explain different type of joins? : Sql dba
What is trigger with example?
How do I quit sql?
What are analytic functions in sql?
discuss about myisam index statistics collection. : Sql dba
Explain the concept of normalization.
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
Oracle (3253)
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)