✂️ Text Tools
| Newlines → Commas | |
| List → IN Clause | |
| IN Clause → List | |
| Newlines → ',' | |
| Count Lines, Words, Chars |
🧩 DML
| SELECT | Copied! |
| INSERT | Copied! |
| UPDATE | Copied! |
| DELETE | Copied! |
| INSERT SELECT | Copied! |
| MERGE | Copied! |
| DELETE EXISTS | Copied! |
| UPDATE JOIN | Copied! |
| INSERT ALL | Copied! |
🏗️ DDL
| CREATE TABLE | Copied! |
| ALTER ADD COLUMN | Copied! |
| MODIFY COLUMN | Copied! |
| RENAME COLUMN | Copied! |
| DROP TABLE | Copied! |
| CREATE SEQUENCE | Copied! |
| CREATE SYNONYM | Copied! |
| TRUNCATE TABLE | Copied! |
| COMMENT ON COLUMN | Copied! |
📊 Aggregation
| Count Employees | Copied! |
| Salary Stats per Dept | Copied! |
| LISTAGG (Names by Dept) | Copied! |
| RANK() by Salary | Copied! |
| DENSE_RANK() by Dept | Copied! |
| Total Salary (SUM) | Copied! |
| Average Salary (AVG) | Copied! |
| Max Salary per Dept | Copied! |
🔗 Joins
| INNER JOIN | Copied! |
| LEFT JOIN | Copied! |
| FULL OUTER JOIN | Copied! |
| SELF JOIN | Copied! |
| ANTI-JOIN | Copied! |
| OUTER JOIN (+) | Copied! |
| CROSS JOIN | Copied! |
| SELF JOIN (ALT) | Copied! |
🧹 String Functions
| SUBSTR | Copied! |
| INSTR | Copied! |
| REPLACE | Copied! |
| LPAD | Copied! |
| LTRIM / RTRIM | Copied! |
🧱 PL/SQL Blocks
| Anonymous Block | Copied! |
| DECLARE + SELECT INTO | Copied! |
| Procedure | Copied! |
| Function | Copied! |
| Exception Block | Copied! |
❗ Exception Handling
| WHEN OTHERS | Copied! |
| VALUE_ERROR | Copied! |
| NO_DATA_FOUND | Copied! |
⚙️ Triggers
| BEFORE INSERT | Copied! |
| AFTER DELETE | Copied! |
| SALARY CHECK | Copied! |
🔧 Built-in Functions
| SYSDATE | Copied! |
| NVL | Copied! |
| DECODE | Copied! |
📅 Date Functions
| ADD_MONTHS | Copied! |
| TRUNC (YEAR) | Copied! |
| LAST_DAY | Copied! |
🔄 Cursors
| DECLARE CURSOR | Copied! |
| OPEN / FETCH / CLOSE | Copied! |
| FOR LOOP | Copied! |
🔁 Transaction Control
| COMMIT | Copied! |
| ROLLBACK | Copied! |
| SAVEPOINT | Copied! |
| ROLLBACK TO | Copied! |
| SET TRANSACTION | Copied! |
🔐 Access Control
| GRANT SELECT | Copied! |
| REVOKE UPDATE | Copied! |
| CREATE ROLE | Copied! |
| GRANT ROLE | Copied! |
📘 Data Dictionary
| USER_TABLES | Copied! |
| USER_TAB_COLUMNS | Copied! |
| USER_CONSTRAINTS | Copied! |
| ALL_OBJECTS | Copied! |