0
What else can I help you with?
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.
Is it possible to change the structure of existing view if yes then how?
using plsql sql
What is the maximum number of handlers processed before the PLSQL block is exited when an exception occurs?
only one
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
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
Where can I download the book Oracle Jdeveloper 10g for Forms and PLSQL Developers by Peter Koletzke and Duncan Mills?
i cant download from ...any where
Addition of two numbers on plsql program?
--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;
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
What is composite data type in plsql?
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
What is triggers in plsql?
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.
