Home » Oracle

PL/SQL get more specific error message for package compile error

Exapmle error: Get more specific error message: Result:

Read More »

Make a Oracle table column nullable

alter table table_name modify (column_name NULL);

Read More »

Create new schema in Oracle SQL Developer

Login as sysdba in oracle developer. Execute the create user statement. For example, create a new user named smith with a password of password as follows: CREATE USER smith IDENTIFIED BY password; Grant specific access to the new schema user….

Read More »