Al Programming
Free source code programming in C#, VB.Net, Java, SQL
Friday, February 18, 2011
Extract hour, minute from date column Oracle
›
Oracle > Extract hour, minute from date column SELECT to_char ( column_date , 'HH24' ) hh , to_char ( column , 'mi...
Wednesday, February 2, 2011
SQL Server Deadlocks
›
SQL Server > Deadlocking Deadlocking occurs when two user processes have locks on separate objects and each process is trying to a...
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...
‹
›
Home
View web version