Pipelined Table functions
Sarfraz Alam
November 13, 2018
A pipelined table function will come up with a single row for the result set and pipe it out of the function when it’s available. Since t...
Showing posts with label PL SQL. Show all posts
Showing posts with label PL SQL. Show all posts
Tuesday 13 November 2018
Wednesday 26 September 2018
Oracle Function returning multiple values
Sarfraz Alam
September 26, 2018
We Can Return multiple values from the function in PLSQL by following steps given below : Create an OBJECT TYPE that contain the colum...
Monday 10 September 2018
Writing Dynamic Insert in Oracle
Sarfraz Alam
September 10, 2018
plsql program to insert data dynamically at runtime by taking input from the user declare val1 number := &Enter_value; ...
Wednesday 29 August 2018
PLSQL code to create a table dynamically at runtime
Sarfraz Alam
August 29, 2018
In this tutorial i will show you the PLSQL code to create a table dynamically at run time DECLARE SQL_STMT VARCHAR2(500); VAL1 VARC...
Monday 20 August 2018
No. of vowels and consonants in a given string in PL/SQL
Sarfraz Alam
August 20, 2018
I have done this question by two methods By using loops declare counts number :=0; counts1 number :=0; str1 varchar2(500) :=...
Reverse a String in PL/SQL
Sarfraz Alam
August 20, 2018
Method 1 : By using FOR loop in PLSQL DECLARE l_string1 VARCHAR2 (100) := 'deeps sti dna thgil neewteb kcuts si emit ehT';...
Friday 10 August 2018
PL/SQL: extract digits from a number
Sarfraz Alam
August 10, 2018
In this PL/SQL program i use nested table to store the digits and then print them in reverse order declare type arr_num is table of ...
Thursday 2 August 2018
Interesting Patterns : PLSQL
Sarfraz Alam
August 02, 2018
declare total_counter1 number :=&10; total_counter2 number :=&10; i number :=1; j number :=1; begin <<outerloop&g...
Monday 9 July 2018
Cursor Expressions in PL/SQL
Sarfraz Alam
July 09, 2018
A cursor expression, denoted by the CURSOR operator, returns a nested cursor from within a query. Each row in the result set of this neste...
Wednesday 20 June 2018
PL/SQL Cursors
Sarfraz Alam
June 20, 2018
what is cursor in PL/SQL? A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement which ...
PL/SQL Cursor examples
Sarfraz Alam
June 20, 2018
example 1 - In this example we use cursor to fetch the name of the employee whose department is IM. declare temp varchar2(20); curso...
sql queries for practise
Sarfraz Alam
June 20, 2018
I have arranged some basic sql queries that will help you to sort out basic query related problems and build your concept also. Here emp ...
