ORA-01400: cannot insert null into (string) Solution

ORA-01400: cannot insert null into (string) Solution

Have you gotten the “ORA-01400: cannot insert null into (string)” error? Learn what causes this and how to resolve it in this article. ORA-01400 Cause If you try to run an INSERT statement to insert data into a table, you may get this error. ORA-01400:... Read more
How Can I Write an Oracle INSERT INTO SELECT Statement?

How Can I Write an Oracle INSERT INTO SELECT Statement?

Are you trying to write an INSERT INTO SELECT statement? Learn how to do it and see some examples in this article. What Is INSERT INTO SELECT? The INSERT INTO SELECT statement allows you to select data from one table and insert it into another table (or the same... Read more
ORA-00972 identifier is too long Solution

ORA-00972 identifier is too long Solution

Have you gotten an “ORA-00972: identifier is too long” error? Learn what caused it and how to resolve it in this article. ORA-00972 Cause If you’re running an SQL statement that refers to another database object (table, view, sequence, synonym, and... Read more
ORA-00001 Unique Constraint Violated Solution

ORA-00001 Unique Constraint Violated Solution

Have you gotten an “ORA-00001 unique constraint violated” error? Learn what has caused it and how to resolve it in this article. ORA-00001 Cause If you’ve tried to run an INSERT or UPDATE statement, you might have gotten this error: ORA-00001 unique... Read more
SQL ORDER BY – The Complete Guide

SQL ORDER BY – The Complete Guide

The SQL ORDER BY clause and functionality is an important part of a SELECT statement. Learn what it does and how to use it in this article. What Is The SQL ORDER BY Clause? The SQL ORDER BY clause allows you to order your results. You can specify what you want to... Read more