Al Programming

Free source code programming in C#, VB.Net, Java, SQL

Wednesday, September 1, 2010

Null data in Oracle using the ORDER BY clause

›
From: Control null data in Oracle using the ORDER BY clause Date: June 19th, 2007 Author: Bob Watkins NULL data, which is sometimes cal...
Monday, June 7, 2010

Oracle/PLSQL: Instr Function

›
Oracle/PLSQL > Functions > Instr Instr function returns the location of a substring in a string. The syntax for the instr Oracle ...
Monday, May 17, 2010

Oracle/PLSQL: Oracle System Tables

›
Oracle/PLSQL > Oracle System Tables -------------------------------------------------------------------------------- Below is an alph...
Saturday, May 15, 2010

Oracle FOR LOOP

›
The syntax for the FOR Loop in Oracle is: FOR loop_counter IN [REVERSE] lowest_number..highest_number LOOP {.statements.} END LOOP; ...

Get current day , month, year Oracle

›
Oracle > Date Time > Get current day , month, year Oracle select to_number(to_char(sysdate,'dd')) day,to_number(to_char(sys...
Thursday, May 6, 2010

SQL COUNT

›
SQL Server   >  Built-in Functions   >  COUNT COUNT returns the number of rows that matches a specified criteria. The NULL values...
Wednesday, May 5, 2010

How to pass Database logon info to a Crystal Report at runtime in C#

›
using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; private CrystalReport1 crReportDocument = new CrystalReport...
‹
›
Home
View web version
Powered by Blogger.