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.
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.
using plsql sql
only one
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement
i cant download from ...any where
Composite types have internal components that can be manipulated individually, such as the elements of an array, record, or table.Oracle TimesTen In-Memory supports the following composite data types:Associative array (index-by table)Nested tableVarrayRecord
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
--THE SUM OF TWO NUMBERS: declare a number(2); b number(2); c number(2); begin a:=&a; b:=&b; c:=a+b; dbms_output.put_line(a ' + 'b' = 'c); end;
a trigger is user defined constraint. A trigger is code that executes based upon an event. A trigger is mostly used on a table and can execute before or after the event. The event that triggers act upon are inserts, updates and deletes on the table or rows in the table.