Profile cover photo
Profile photo
Biju's Oracle Notes
14 followers -
#oratidbit - Tips and tools related to Oracle
#oratidbit - Tips and tools related to Oracle

14 followers
About
Communities and Collections
Posts

Post has attachment
The Oracle Optimizer and ADWC - Hints
Add a comment...

Post has attachment
The Oracle Optimizer and ADWC - Statistics-Based Query Transformation
Add a comment...

#oratidbit PL/SQL data type PLS_INTEGER has advantages over the NUMBER data type. Requires less storage and uses hardware arithmetic, so they are faster than NUMBER operations, which use library arithmetic.
Add a comment...

Post has attachment
The Oracle Optimizer and ADWC - Statistics and Bulk Load
Add a comment...

#oratidbit #sqlcl SET HISTORY BLACKLIST allows you to set the commands that should not be recorded in history. By default, the SHOW, HISTORY, CONNECT, and SET commands are not saved in history.
Add a comment...

Post has attachment
Introducing SQLdb360: merging eDB360 and SQLd360, while rising the bar to community engagement
Add a comment...

Post has attachment
Creative Solutions Using Oracle Data Pump
Add a comment...

#oratidbit #SQLDev SQL Developer provides interactive advisories in the code editor identifying code that is at risk of SQL injection. First-order injection is when user-specified data from function parameters is used in a dynamic SQL statement that can be exploited.
Add a comment...

Post has attachment

#oratidbit #db18c #SQLDev #ADWC SQL Developer 18.1 Data Import Wizard can load data from files in the Oracle Cloud (or local storage) to Autonomous Data Wareshouse Cloud using the DBMS_CLOUD API.
Add a comment...
Wait while more posts are being loaded