SELECT table_name, constraint_name, cname1 || Nvl2(cname2,’,’ ||cname2,NULL) ||Nvl2(cname3,’,’ ||cname3,NULL) || Nvl2(cname4,’,’ ||cname4,NULL) [...]

Renaming a pluggable database   After renaming the pdb we need to  move the datafiles to new directory if needed.

Masking a column using dbms_redact   To mask a sensitive data from any column using dbms_redact package. Here profile column in redactt table is masked. [oracle@tom ~]$ !sq sqlplus / as [...]

The sys and dba privileged schemas can view the details of columns masked using DBMS_REDACT .

Importing excel data to oracle table using sqldeveloper Choose the table and right click Uncheck Header Select columns Choose match by position  

To find the job details set pages 1000 lines 1000 col schema_user for a20 col this_date for a20 col next_date for a20 col what for a80 col instance for 999999999 select [...]

  Download sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip set db environment cd /home/oracle unzip sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip cd sqlt/install sqlplus / as sysdba sql> start [...]

set lines 1000 pages 1000 col RBS format a20 col sid format 9999 col user format a28 col status format a12 SELECT r.name “RBS”, s.sid, s.serial#, s.username “USER”, [...]

TO FIND THE CURRENT SCN ======================== select current_scn from v$database; TO FIND THE SCN FROM TIMESTAMP =============================== select [...]

set pages 1000 lines 1000 col column_name for a40 col index_name for a45 col column_expression for a40 set lines 120 pages 50000 select c.index_name, c.column_name “COLUMN_NAME”, [...]