Al Programming
Free source code programming in C#, VB.Net, Java, SQL
Thursday, December 30, 2010
Select a random records SQL SERVER, Oracle, MySql
›
Database > Random Records --Select random rows with Microsoft SQL Server --NEWID Creates a unique value of type uniqueidentifier . S...
How to extract words out from a string c#
›
C# > String > Spilt Split returns a string array that contains the substrings in this instance that are delimited by elements...
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...
‹
›
Home
View web version
