Tips to create table

Create table with following default columns always

1. ID (Unique values)
2. Created_by
3. Creation_date default sysdate
4. updated_by
5. last_update_date
6. Enable default ‘1’ /* 1 = Enabled , 0 = Not Enabled */Create sequence for every table to generate auto number, with the same name as table, add sq_ as prefix.

Create trigger for unique column in table and use sequence to populate values.

Script:

Create table EMP (
Emp_id number, -- Primary Key Column
Name varchar2(100),
DOB date,
Created_by number,
Creation_date date default sysdate,
Last_updated_by number,
Updation_date date,
Enabled number(1) /*default value 1*/
);

Create sequence sq_emp;

Create trigger tbi_table_name
Before insert on emp
For each row
Begin
If :new.emp_id is null then
Select sq_emp.nextval into :new.emp_id from dual;
End if;
End;
/

Insert into Emp(
emp_id,
name,
DOB,
created_by
,creation_date
,Enabled) Values
(null,
'Amjad Ali',
'31-Dec-1974',
100, -- User id which would be available in other table user.
Sysdate,
'1');

Commit;

Select * from Emp;