Codbix
  • Home
  • Garden
  • Notes
  • Collections
  • Projects
  • Tags
  • About

#pl-sql

Oracle Timestamp

Oracle Timestamp

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);

Reference

dba-oracle dba-oracle 2

Read more

Drop table in PL SQL

PL SQL Query to list the currently running jobs.
Read more

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.
Read more

Oracle NLS / National Language Suppport

The nls_database_parameters shows the values of the NLS parameters for the database.
Read more

List of jobs and jobs history - PL/SQL

PL SQL Query to list the currently running jobs.
Read more

List the months between two dates - PL/SQL

PL SQL Query to list the months between two dates.
Read more

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...
Read more

PL/SQL Ref Cursor

A cursor variable is a cursor that contains a pointer to a query result set....
Read more

PL/SQL Pseudocolumns

A pseudocolumn behaves like a table column, but is not actually stored in the table.
Read more
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Bino Kochumol Varghese  • © 2023  •  Codbix

Powered by Hugo  •  Theme Lightbi adapted from Beautiful Hugo  •  Made with ✨ by Bino