Home » Oracle

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 »