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

Is the primary key an index?

981

---

When are we going to use truncate and delete?

925

---

What are the limitations of sql express?

982

---

What is the difference between a primary key and a clustered index?

926

---

How do I order by ascending in sql?

954

---

Why do we create views in sql?

1049

---

what is index? : Sql dba

942

---

Does inner join return duplicate rows?

925

---

What is the difference between function, procedure and package in pl/sql?

1131

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1066

---

What is raw datatype in sql?

976

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985

---

Is primary key a clustered index?

909

---

Mention what plvcmt and plvrb does in pl/sql?

1061

---

Which is faster truncate or drop?

978

---