Table Indexes Snippets


23 October, 2014   

Rebuild indexes on a mySQL table.

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.

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

23 November, 2013   

Lets say you have a table with field called "tags" that consists from tags separated by commas and you want to check whether it includes a required tag. Here the simplest ways of doing that.

16 March, 2014   

How to create mysql table using php. The php script as follows as:

24 June, 2015   

Create a table with the results from a SELECT statement.

27 March, 2013   

CSS code for table-layout property using an example code in html page.

21 December, 2013   

The following table has a caption. The first row and the first column contain table header cells only; other cells are data cells.

In this example we will select everything in our table "example" and put it into a nicely formatted HTML table.

14 August, 2014   

Easy way to copy the contents of one table to another table.

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

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.

11 July, 2013   

It can be inserted into the newer table without any hassles over an incompatible number of fields.

Here are the procedure example to create table. you can call this procedure by command like : call myProc();

Here are the example to create temporary table in a procedure .

Simplest way to to export a MySQL table to a pipe delimited file.

The code includes the CSS which you can add to your stylesheet and please note a class has been added to the table tag.

23 March, 2016   

Get contents of table where the item does NOT exist in another table.

23 October, 2012   

MySQL code example to optimize all tables of database

02 November, 2014   

The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.