Let's Develop in Oracle
DML Error Logging - DBMS_ERRLOG.CREATE_ERROR_LOG
View results of refcursor out parameter
Query optimization tips for Oracle
Index Hints and Like Clause
Query Optimization - Handling NULL Values
Query Optimization - Function Based Index
Query Optimization - OR and Union
Query Optimization - Simplified Conditions
Query Optimization - Not In
Query Optimization - Join Query
Query Optimization - Single table
ORA-06512: at line num
ORA-28002: the password will expire within 7 days
Create External Table from CSV File
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-01489: result of string concatenation is too long
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-00600 internal error code
ORA-00020 maximum number of processes exceeded
Alter VARCHAR2 Column To CLOB
SQL Interview Question Answers
ORA-01555: snapshot too old
ORA-00027 cannot kill current session
ORA-00257 archiver error. Connect internal only, until freed
Reliance 3g automatically disconnects solution
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)