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

Are sql database names case sensitive?

1052

---

What is the difference between execution of triggers and stored procedures?

1157

---

What is consistency?

1187

---

When sql appeared?

1148

---

what are the different type of normalization? : Sql dba

1072

---

what are the advantages of sql ? : Sql dba

1110

---

State few characteristics of pl/sql?

1024

---

Can we create view in stored procedure?

1026

---

Which is faster union or join?

1027

---

Why do we use procedures in sql?

1141

---

What is the difference between unique and primary key constraints?

1122

---

Is not null in sql?

1045

---

What is the difference between sql, mysql and sql server?

1176

---

how to start mysql server? : Sql dba

1239

---

Explain how exception handling is done in advance pl/sql?

1046

---