Browsing: scripts

select instance_name, con_id, version from v$instance; select name, con_id, db_unique_name from v$database; select dbid, con_id, name from v$pdbs; alter session…More

Select * from v$version; //Version of the DB Select * from dual; SELECT * FROM dba_users; SELECT username FROM all_users…More

An Identity column auto increments on input, introduced from Oracle 12C, it’s a useful for the surrogate primary key column.…More

This adds months to the current date; ie. SELECT ADD_MONTHS( DATE ‘2016-02-29’, 1 ) FROM dual; Reference: Oracle Tutorial.comMore

To return the current date in Oracle Database, use; SELECT CURRENT_DATE FROM DUAL; To get the Session Time zone; SELECT…More