Sql Query Snippets

11 July, 2013   

Help manage mysql database common task

08 September, 2012   

SQL query to know total number of employee on each department.

08 September, 2012   

SQL query to know employees where city is null

01 October, 2013   

This class has lots of common functionality built right into it. It also supports Mysql and Sphinx.

PHP & Mysql based code to Print table with client-side sorting function.

31 October, 2011   

It is a class file which can export to excel. simply call the function and give sql Query and sql connection.

An example code to restore MSSQL database from backup

07 December, 2013   

Example code for Oracle Cursor Query

14 September, 2013   

An example for MySQL Results To Array

19 March, 2011   

Showing here an example of PL SQL Query

20 February, 2012   

SQL select query to show records with specify date in where clause

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

10 October, 2012   

This query will return the amount of records for the query

21 January, 2012   

PL/SQL Block that uses implicit cursor attributes as below example code.

This is an example for Form Based Query

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

20 February, 2012   

SQL select query with between date to show records in where clause

Basic Database Connection, Random Query, Display Result

20 October, 2012   

Create dynamic variables from a query or a list.

01 December, 2011   

The following code block shows how to run DML statements in PL/SQL. Basically they look similar to the SQL. Note that the SELECT statement retrieves the single-row value and store into a variable using INTO clause.