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

#Database

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

Relational Model

A relational database is a database that conforms to the relational model....
Read more

PL/SQL Pseudocolumns

A pseudocolumn behaves like a table column, but is not actually stored in the table.
Read more

PL/SQL ROWNUM

ROWNUM is a pseudocolumn (not a real column) that is available in a query. ROWNUM will be assigned the numbers 1, 2, 3,
Read more

Validate Conversion

VALIDATE_CONVERSION determines whether `expr` can be converted to the specified data type.
Read more

The SELECT INTO Clause

The SELECT INTO is actually a standard SQL query where the SELECT INTO clause is used to place the returned data into predefined...
Read more
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Bino Kochumol Varghese  • © 2023  •  Codbix

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