SQLcl has many new little tricks that can help us on a daily basis, below is an example how we can execute SQLcl command from SQL developer: Here is an info <table> Here is an DDL for the same table: ddl <table name> Advertisements Continue reading Run SQLcl commands from SQL Developer
in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME. After review the contents on more then 1800 events, I noticed the most display name were the same as the name with exception of a 19. Here are they: Continue reading 12c DISPLAY_NAME column in v$event_name view
Download Instant Client for macOS http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst Continue reading Install sqlplus instant client on macOS
When logging in SQL*PLus if one receives the following message. SQL> connect scott/tiger Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM This can be fixed by executing as SYSTEM SQL> @?/sqlplus/admin/PUPBLD.SQL .. And after the script is run reconnect as the user. SQL> connect scott/tiger Connected. Continue reading How to fix “Error accessing PRODUCT_USER_PROFILE”?
Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is optional SQL> timing start monitor_timing SQL> select sysdate from dual; SYSDATE ——— 11-APR-10 — display time elapsed for current timer SQL> timing show timing for: monitor_timing Elapsed: 00:00:21.35 SQL> select count(1) FROM dba_objects; COUNT(1) ———- 9728 — show elapsed time SQL> timing show timing for: … Continue reading Using timing in SQL*Plus
If a SQL script file has blank lines in between SQL statements one may see errors when executing the script in SQL*Plus so if one would like to ignore the blanklines in SQL*Plus one can ignore them by set blanklines on. Example: SQL> select object_name 2 SQL> from dba_objects; SP2-0734: unknown command beginning “from dba_o…” – rest of line ignored. SQL> set sqlblanklines on SQL> … Continue reading How to skip blank lines in between SQL statements in SQL*Plus?