Database Topics

Database Topics

When to use a semicolon or a slash in Oracle

When to use a semicolon or a slash in Oracle SQL? Determining whether to use a semicolon and when to use a slash in Oracle script is difficult. Oracle will give an error if the semicolon and slash are misplaced.

ORA-02286: no options specified for alter sequence

ORA-02286: no options specified for ALTER SEQUENCE error occurs when you try to modify a sequence without specifying any parameters, or when you provide wrong parameters. You try to modify a sequence with an invalid argument or no parameter at

ORA-02449: unique/primary keys in table referenced by foreign keys

ORA-02449: unique/primary keys in table referenced by foreign keys error occurs when you try to drop the parent table without removing the foreign key in a parent-child relationship established between two tables. Two tables are created with a parent-child relationship

ORA-02291: integrity constraint (HR.SYS_C0012551) violated – parent key not found

ORA-02291: integrity constraint violated – parent key not found error occurs when a foreign key value in the child table does not have a matching primary key value in the parent table, as stated by a foreign key constraint. You

Most Viewed