Oracle Query Snippets


07 December, 2013   

Example code for Oracle Cursor Query

19 March, 2011   

Showing here an example of PL SQL Query

09 April, 2013   

How to "bounce" an Oracle database

14 May, 2012   

PL SQL Descending order in Oracle

14 September, 2013   

An example for MySQL Results To Array

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

07 August, 2014   

All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.

10 October, 2012   

This query will return the amount of records for the query

This is an example for Form Based Query

29 March, 2015   

When creating an index, the default method Oracle uses to sort the index is in ascending order (SORT). However, if the rows are already stored in the database in ascending order you can use the NOSORT clause to skip the sorting process. If neither SORT or NOSORT is provided, Oracle will use SORT as the clause.

Basic Database Connection, Random Query, Display Result

20 October, 2012   

Create dynamic variables from a query or a list.

PL/SQL code example to create and call an oracle function

Code example for Connecting to Oracle using Java JDBC

Note that to add a new column to the query, just add in an input box to the HTML, the PHP generates an insert for each field.

14 March, 2013   

PHP code example to process MySQL Timestamp

This is a very handy query that sorts your tables by their physical size in megabytes. Just be sure to edit the query to include the database name.

23 October, 2012   

MySQL code example for sorting data in a GRID

25 October, 2014   

DBCA is what you need to create a test database in only 5 mins.

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