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.
Code example for TSQL COVERING INDEX
: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.
Here shown how to define a Custom Selector
How to display visitors IP in an Image using PHP
Create dynamic variables from a query or a list.
Example code for smarty Loop for x to y with no array
An example pure CSS Tooltip
jQuery code example for animated scroll
There are two methods for creating separate styles depending on the media type. both example given below:
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.
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...
Example shows here how to create JSON data in Java
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.
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.