1.
Ask Anantha: EXP-00056: Oracle Error when trying to export 10.2 ...
Deleting duplicate rows from Oracle Table · How to validate values in PL/SQL .... EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, ...
2.
Ask Anantha: EXP-00056: Oracle Error when trying to export 10.2 ...
*NEW* Click here to Ask Anantha your Oracle Query ... EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41:PLS-00302: component ...
3.
Ask Anantha: Oracle Hints
Oracle Hints. /*+ ALL_ROWS */. Explicitly chooses the cost-based .... Causes Oracle to join each specified table with another row source with a hash join ...
4.
Ask Anantha: How to rename a table in Oracle?
This blog contains articles on varied topics on Oracle SQL, PLSQL, Forms, ... The minimum version that supports table renaming is Oracle 8i. ...
5.
Ask Anantha: How to rename a table in Oracle?
The minimum version that supports table renaming is Oracle 8i. All the dependencies of the table will automatically updated. No need of updating them after ...
6.
Ask Anantha: What is difference between UNIQUE and PRIMARY KEY ...
What is difference between UNIQUE and PRIMARY KEY constraints. Both UNIQUE and PRIMARY KEY constraints enforce uniqueness in the column. ...
7.
Ask Anantha: Making Oracle Case insensitive
The following query can be executed to get case insensitive output: SELECT * ... Click here to read How to Change Oracle back to Case Sensitive once again ...
8.
Ask Anantha: Making Oracle Case insensitive
Click here to read How to Change Oracle back to Case Sensitive once again. Read More... Collapse. ... Ask Anantha Search. Ask Anantha (Our latest articles) ...
9.
Ask Anantha: Oracle Hints
Query to find out queries running in database · FRM-40502: ORACLE error: unable to read ... Oracle Hints. /*+ ALL_ROWS */. Explicitly chooses the cost-based ...
10.
Ask Anantha: Script for getting Oracle table size
Script for getting Oracle table size. There is no oracle defined function for getting size of a table. After all if it is easy with one simple query who ...