-

Comments

Post a Comment

Popular posts from this blog

What is types/collections in Pl/SQL?

-
Collection Types in PL/SQL Types : Type is nothing but user_defined datatype. In oracle we can create our own datatype. We can create user_defined datatype by using type keyword.There are various types of collection in Pl/SQL following lines. 1)PL/SQL record 2) index by table (or) pl/sql table (or) associative array 3) nested table 4) Varray 5)ref cursor* (will be in next) Note: where index by table ,nested table and Varray are also known as collections. Index by table: It is a type. Which stores number of values into a single unit. It improves application performance because it stored in RAM MEMORY AREA.Index by table has key-value pair. Where key behaves like a primary key. which stores index. Key doesn't have any duplicate value in it. Where value is actual data. To improve performance of the index by table oracle provided binary_integer datatype for key field. Index by table,nested table, Varray are also called as collections. Oracle provided predefi...
Read more

How to use a function in Oracle PL/SQL?

-
Image
What is a Function in Oracle PL/SQL Function : The PL/SQL Function is very identical to PL/SQL Procedure.The big dissension between procedure and a function, a function essential always return a value, but procedure may or may not return a value.     Functions is also used to solve a particular task like procedure. Function always returns a value.Oracle provided us a facility to create our own functions to solve any task.   How To Create a function    Syntax: Create or replace function p1 (formal parameters) return datatype is variable,cursor, user_defined exception  begin ...... return expression; // Do not use dbms_output.put_line() exception ....... end; _________________________________________________________________________________ Execution: Method 1:   Select function_name from dual; Method 2: By anonymous block           Syntex:           declare ...
Read more