Archived Articles from the Category Oracle
- Role of MERGE command? What's Upsert Functionality?
- DDL, DML, DCL, and TCL - what are they used for?
- SQL Query to find the lowest/top N records based on a column
- Difference between RANK() and DENSE_RANK() functions
- Difference between VARCHAR and VARCHAR2
- SQL Query to find every Nth row from a table
- SQL Query to remove duplicate records from a table
- Difference between DELETE, DROP, and TRUNCATE
- What is a Database Transaction?
- What's a relational DB? What are Integrity Rules?
- Difference between Server-side and Client-side DB Cursor
- Oracle Database - How to tune it for better performance?
- All types of Database Files used in Oracle Database
- Library Cache vs Data Dictionary Cache in Oracle DB
- SGA Memory Structure of the Oracle Database
- Oracle Server Architecture - Primary Components
 |
RSS Feed (xml)
No comments:
Post a Comment