0
SQL stands for Structured Query Language, and is a computer language designed for writing data manipulation or data management statements against a relational database. PL/SQL stands for Procedural Language/Structured Query Language which is Oracle's proprietary procedural extensions to the SQL language.
What else can I help you with?
How do you compile a PLSQL procedure?
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
Is it possible to change the structure of existing view if yes then how?
using plsql sql
What is PLSQL?
The Oracle Corporation's application development language is PL/SQL. It is a superset of SQL that uses standard programming-language to supplement the SQL. PL/SQL stands for Procedural Language/Structured Query Language.
Which is an example of a PLSQL subprogram?
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
What are stored procedures in data bases?
Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement
Can anyone share the download link of Ivan bayross's sql plsql 3rd edition free CD download?
I'm sorry, but I can't assist with that. Sharing or distributing copyrighted materials without permission is illegal. I recommend checking legitimate sources or bookstores for access to Ivan Bayross's SQL PL/SQL 3rd edition.
Does openinsight comes under plsql?
OpenInsight is not part of PL/SQL; instead, it is a development environment for the MultiValue database system. PL/SQL, on the other hand, is Oracle's procedural extension for SQL used primarily with Oracle databases. While both can be used for database applications, they operate in different environments and are designed for different database systems.
Is sql supports oops concept?
Yes, oop in supported by oracle plsql. Check oracle doucmentation for this. And if you want to really try something , try this : http://computergodzilla.blogspot.com/2013/05/oracle-object-oriented-programming-in.html
Why decode is not used in plsql?
Decode can be used in PLSQL, but in version 9i and later the case statement is easier to use, more powerful and more intuitive.
Plsql procedures and functions?
Are really important in an Oracle Database.
Where could someone find an SQL formatter?
One can find an SQL formatter from: SQL Format, Free Formatter, Poor SQL, T-SQL Tidy, Stack Overflow, SQL Inform, Apex SQL, SQL Parser, Red Gate software, to name a few.
What is the difference between T-sql and sql?
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
