Syntax Description of the illustration listagg.gif Purpose For a specified measure, LISTAGG orders data within each group specifie...
Read More
XMLAGG in oracle
Syntax Description of the illustration XMLAgg.gif Purpose XMLAgg is an aggregate function. It takes a collection of XML fragments ...
Read More
ORACLE/PLSQL: SIGN FUNCTION
This Oracle tutorial explains how to use the Oracle/PLSQL SIGN function with syntax and examples. DESCRIPTION The Oracle/PLSQL SI...
Read More
SQL SERVER: REPLACE FUNCTION
SQL SERVER: REPLACE FUNCTION This SQL Server tutorial explains how to use the REPLACE function in SQL Server (Transact-SQL) with syn...
Read More
Happy Birthday to Dr.A.P.J.Abdul Kalam
Wish You Happy Birthday to our Honorable former President Dr.A.P.J.Abdul Kalam Wish You...
Read More
TNPSC Group 2 A Services
Combined Civil Services Examination-II (Non-Interview Posts)(Group-II A Services) Advt. No./ Date of Notification : 17/2015 ...
Read More
Creating Excel File in Oracle Forms
Below is the example to create an excel file in Oracle Forms. Pass the Sql query string to the below procedure to generate an Excel file us...
Read More
Subscribe to:
Posts
(
Atom
)