Recent posts
View all
Sql
Script to find details of Data Definition, Template, File Name of a Concurrent Program
Script: Provide Concurrent Program Short Name, Application Name (Eg. General Ledger) to the following script. It gets Data Definition information…
Learn More »
PLSQL
How to split a string in oracle into variables based on the separator?
Say to split the below string into 4 variables based on the separator : l_string : = ‘AAAA:BBBB:CCCC:DDDD’; l_var1:= ‘AAAA’; l_var2:= ’BBBB’; l…
Learn More »
Sql
Query to get profile options details from backend
SELECT fpov.profile_option_name , fpov.user_profile_option_name, DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002…
Learn More »
PLSQL
REF Cursor in Plsql
REF CURSOR : A REF Cursor or Cursor Variable is just reference to static cursor or handle to static cursor. It allows user to pass this ref…
Learn More »
PLSQL
Autonomous Transaction In PLSQL
Autonomous Transaction : An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonom…
Learn More »
