PL/SQL Pseudocolumns

Bino Kochumol Varghese /   July 27, 2022

A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values. A pseudocolumn is also similar to a function without arguments (refer to Functions). However, functions without arguments typically return the same value for every row in the result set, whereas pseudocolumns typically return a different value for each row.

Rownum is an example for pseudocolumns.

References

Oracle Docs

pl-sql Database

Use the share button below if you liked it.

It makes me smile, when I see it.

Read More

DIRECTORY Objects in plsql

Bino Kochumol Varghese /   March 2, 2023

Catalog views are provided for DIRECTORY objects to enable users to view object names and corresponding paths and privileges.
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