Creating Index Snippets


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.

31 July, 2012   

Code example for TSQL COVERING INDEX

02 July, 2012   

:even and :odd (Select elements with an even index or odd index elements. The index starts from 0.)

Normally index.html or index.php is the default page a server serves up when visiting a directory without specifying a file name. You can change this with .htaccess:

Convert a coordinate (x,y) into the index for a 1D array. For example, the coordinate (3,1) would be at array index 8 if there are 5 columns. Assumption: Arrays start at 0.

22 August, 2011   

Here shown how to define a Custom Selector

How to display visitors IP in an Image using PHP

20 October, 2012   

Create dynamic variables from a query or a list.

If you're looking for a great way to enable your visitors to navigate your web site, this JavaScript drop down box with automatic redirect may be what you're looking for. This JavaScript code will enable your visitors to click on a drop down box to select the location on your web site in which they would like to navigate. Once they make their...

26 November, 2012   

Example code for smarty Loop for x to y with no array

27 February, 2013   

An example pure CSS Tooltip

28 January, 2012   

JavaScript Code example to choose a page and Jump

30 January, 2013   

jQuery code example for animated scroll

06 March, 2013   

There are two methods for creating separate styles depending on the media type. both example given below:

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 September, 2011   

Example code showing how to add a primary constraint. This Oracle constraint is used to identify the primary key for a table. A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. This...

06 June, 2013   

Example shows here how to create JSON data in Java

29 August, 2011   

Be careful that these boxes aren't sitting within another element that has a background, otherwise the negative z-index values (required for this to work) will force the shadows underneath that and not show up.

28 February, 2013   

This function takes a string and an output buffer and a desired width.

This little function comes in handy. There's nothing worse than seeing a site with a copyright out of date.