We have moved to a new website!
If you are not redirected within 3 seconds, click here to go my homepage.
DIRECTORY Objects in plsql
Catalog views are provided for DIRECTORY objects to enable users to view object names and corresponding paths and privileges.
The TIMESTAMP datatype is an extension on the DATE datatype. In addition to the datetime elements of the DATE datatype, the TIMESTAMP datatype holds fractions of a second to a precision between zero and nine decimal places, the default being six. There are also two variants called TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE. As their names imply, these timestamps also store time zone offset information.
create table table_name ( column_name number, column_name2 timestamp default systimestamp);
Column-Level Collation and Case-Insensitive Database in Oracle
Collation determines how strings are compared, which has a direct impact on ordering (sorting) and equality tests between strings.
Oracle NLS / National Language Suppport
The nls_database_parameters shows the values of the NLS parameters for the database.
List the months between two dates - PL/SQL
PL SQL Query to list the months between two dates.
Difference Between Cursor And Ref Cursor
A ref cursor can be passed to another PL/SQL routine (function or procedure) or returned to a client...