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.
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
using plsql sql
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.
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement
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
Decode can be used in PLSQL, but in version 9i and later the case statement is easier to use, more powerful and more intuitive.
Are really important in an Oracle Database.
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.
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
Sql Forms Sql Forms
ANSI SQL is the American National Standards Institute standardized Structured Query Language. ANSI SQL is the base for several different SQL languages such as T-SQL and PL/SQL. ANSI SQL is used to Create, Alter, and View data stored within a database. For more information about ANSI: http://www.ansi.org/ For more information about SQL: http://en.wikipedia.org/wiki/SQL