Answer Posted / akshay

yes it possible using trigger
Create sequence S_Number
start with 1
increment by 1;


create trigger Pri_key before insert on table(C1)
for each row
Variable number(5);
begin
select sequence.nextvalue into Variable;
insert into table c1 value(variable);
end

How to raise user-defined exception with custom sqlerrm ?

1114

---

What is the difference between database trigger and stored procedure?

1054

---

Is and as keyword in pl sql?

942

---

what is heap table? : Sql dba

1090

---

What is the starting oracle error number? What is meant by forward declaration in functions?

969

---

What are the different types of joins in sql?

1731

---

how many triggers are allowed in mysql table? : Sql dba

1037

---

What is rownum?

961

---

What are the rules to be applied to nulls whilst doing comparisons?

1307

---

How to write html code in pl sql?

1096

---

Do we need commit after truncate?

1062

---

Why do we use subquery?

991

---

Is delete faster than truncate?

993

---

Is natural join and inner join same?

900

---

List different type of expressions with the example.

925

---