SQL

How to Revert INSERT INTO by DELETE FROM Statements

Posted on
Revert INSERT INTO Suppose that you have created two rows by INSERT INTO statements like this: SQL> INSERT INTO HR.EMPLOYEES (EMPLOYEE_ID, LAST_NAME, EMAIL, HIRE_DATE, JOB_ID) VALUES (207, ‘Chen’, ‘chen@example.com’, ’25-APR-19′, ‘SA_REP’); 1 row created. SQL> INSERT INTO HR.EMPLOYEES (EMPLOYEE_ID, LAST_NAME, EMAIL, HIRE_DATE, JOB_ID) VALUES (208, ‘Smit’, ‘smit@example.com’, ’25-APR-19′, ‘FI_MGR’); 1 row created. If you are […]
SQL

How to Resolve ORA-00903: invalid table name

Posted on
In this post, I will introduce 3 main error patterns about ORA-00903, they are: Violating Naming Rules Missing Quotes Incorrect Syntax ORA-00903 due to Violating Naming Rules Without complying with database object naming rules, we can’t create a table with unusual strings in normal way. Let’s see some cases that throw ORA-00903. First of all, […]