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... Read More
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... Read More
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; ... Read More
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... Read More
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) :=... Read More
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';... Read More
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 ... Read More