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

Bino Kochumol Varghese /   March 2, 2023

ALL_DIRECTORIES (OWNER, DIRECTORY_NAME, DIRECTORY_PATH)
This view describes all directories accessible to the user.

SELECT * FROM ALL_DIRECTORIES;

DBA_DIRECTORIES(OWNER, DIRECTORY_NAME, DIRECTORY_PATH)
This view describes all directories specified for the entire database.

SELECT * FROM DBA_DIRECTORIES;
References

Oracle Doc

pl-sql

Use the share button below if you liked it.

It makes me smile, when I see it.

Read More

Oracle Timestamp

Oracle Timestamp

Bino Kochumol Varghese /   December 21, 2022

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

Bino Kochumol Varghese /   October 25, 2022

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

Column-Level Collation and Case-Insensitive Database in Oracle

Bino Kochumol Varghese /   October 24, 2022

Collation determines how strings are compared, which has a direct impact on ordering (sorting) and equality tests between strings.
Read more