Stored Pl Sql Snippets


18 June, 2012   

An example of Stored PL/SQL blocks

12 January, 2013   

Search the source code of all stored procedures.

How to get returning value from a stored procedure

Using a stored procedure as the source in an OLE_DB Source for SSIS, the package can’t detect the output of the stored proc.

01 January, 2014   

Example shown here how to call a stored procedured in C#

This stored sql procedure is used to replace a special character (or string) of your field with another string.

21 January, 2012   

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

05 September, 2011   

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful.

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.

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

Exam code to backup MySQL Database to SQL File

18 January, 2012   

SQL GROUP BY Clause returns group of rows. An example code for SQL GROUP BY clause

In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.

PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output. The special feature about PL/SQL is that a procedure/function argument can be of input (indicating the argument is read-only), output (indicating the argument is write-only) or both (both readable and...

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

13 May, 2013   

You can also run this an anonymous SQL Block

19 December, 2012   

How to convert a java util Date into a sql Date for use in databases.

11 July, 2013   

Help manage mysql database common task

21 January, 2012   

PL/SQL code example for Explicit Cursors