Oracle tutorial : Pseudo columns in Oracle PL SQL (pseudo column)

Oracle tutorial : Pseudo columns in Oracle PL SQL ( pseudocolumn )

oracle tutorial for beginners

rownum in oracle

This video will show you what is Pseudo columns in Oracle PL SQL.

Pseudo columns are likes ROWNUM, ROENUM, ROWID, NEXTVAL,SYSDTAE , USER etc.

pseudocolumn examples

Oracle tutorial : Pseudo columns in oracle

Oracle supports several special-purpose data elements that are not actually contained in a table, but are available for use in SQL statements.

Here is a partial list of pseudo-columns in Oracle

a)CURRVAL : When using Oracle SEQUENCE values, the pseudo-column CURRVAL returns the current value of
the sequence.

b)NEXTVAL :When using Oracle SEQUENCE values, the pseudo-column NEXTVAL returns the next value of
the sequence and causes the sequence to increment by one.

c)ROWNUM:ROWNUM returns a number indicating the order in which a row was selected from a table.
d)ROWID: ROWID returns the rowid (binary address) of a row in a database table.

e)USER :This pseudo-column will always contain the Oracle username under which you are connected to the database.

f)SYSDATE:This pseudo-column will contain the current date and time.
This column is a standard Oracle DATE datatype.
The value represents the current time on the server not the client.

For more tutorial please visit #techquerypond