Blogs about: Pl Sql
Featured Blog
IF-THEN-ELSE in SELECT statement : DECODE function
U may refer to another source for basic use of DECODE This example show how I use it to separate a field to 3 different columns based on it value (+ve, 0, -ve)…. SELECT DECODE( SIGN(gl_open_amt)… more →
Atoksyah's Weblog
Using Oracle PL SQL to bulk load XML
Nick wrote 2 weeks ago: In performance testing it is often necessary to do bulk loads of data into databases via XML payload … more →
How to insert using Cursor in Oracle
aliraza wrote 2 months ago: Being a .net technologies guy I never be go on database level. but last night I have to face a small … more →
Oracle Tips and Tricks
— 2 comments
Varun wrote 2 months ago: This post is intended to make it a small reference bible for all Oracle lovers (developers as well a … more →
IF-THEN-ELSE in SELECT statement : DECODE function
atoksyah wrote 4 months ago: U may refer to another source for basic use of DECODE This example show how I use it to separate a f … more →
Oracle PLSQL - to_char
jecosen wrote 6 months ago: Syntax : — converts a number or date parameter to a string. to_char( number_or_date_param , [ … more →
Oracle PLSQL - Date Format
jecosen wrote 6 months ago: Format Description YEAR Year, spelled out YYYY 4-digit year YYY YY Y Last 3, 2, or 1 digit(s) of yea … more →
Oracle PLSQL - to_date
jecosen wrote 6 months ago: Syntax : – converts a string parameter to a date to_date ( string_param , [ format_mask ] , [ … more →
Custom Script to Identify Invalid Packages
mohibalvi wrote 7 months ago: Identifying Invalid Objects SELECT owner, object_type, object_name, status FROM dba_objects WHERE st … more →
Oracle Supplied Packages
mohibalvi wrote 7 months ago: DBMS_SQL Using DBMS_SQL, one can write stored procedures that use dynamic SQL. It can issue data def … more →
Log4PL/SQL - Log Api For PL/SQL
Ahmet Fuat Sungur wrote 7 months ago: Log4PL/SQL In some situations you need to developed big applications with PL/SQL. And you want to se … more →
Oracle SQL Query: Retrieve Hours & Minutes
atoksyah wrote 7 months ago: This simple query will retrieve hours and minutes from a number of days. If u dont undestand Malay, … more →
PL SQL Collections and Records
mohibalvi wrote 8 months ago: Composite Data Types Are of two types: – PL/SQL RECORDs – PL/SQL Collections – IND … more →
PL SQL BASICS
mohibalvi wrote 8 months ago: Declaring PL/SQL Variables v_hiredate DATE; v_deptno NUMBER(2) NOT NULL := 10; v_location VARCHAR2(1 … more →
Dynamic SQL with Temporary Table
wihemdra wrote 8 months ago: Sometimes we’re using temporary table using #name. But it can’t be use inside dynamic qu … more →
Pairing Java objects with Oracle Types
Ahmet Fuat Sungur wrote 8 months ago: When you send your java object variables to Oracle, you can divide objects into attributes, then sen … more →
Running os commands from Oracle
— 1 comment
labite wrote 9 months ago: I was looking for a way to execute os commands from Oracle, all solutions I found were very complex, … more →
PROCEDURE: MSG( varchar2 )
atoksyah wrote 9 months ago: This procedure show an MESSAGE alert. U must hv an alert named ‘MESSAGE’ before use this … more →
PROCEDURE: ERR( in varchar2 )
atoksyah wrote 9 months ago: This procedure show an ERROR alert. U must hv an alert named ‘ERROR’ before use this pro … more →
PROCEDURE: PR_DESTROY_PARAMETER_LIST( in varchar2)
atoksyah wrote 10 months ago: I use this procedure to make sure the parameter list doesn’t exist. This is important as an er … more →
