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

What is primary key and foreign key?

962

---

What is nested table in pl sql?

1073

---

What is the need of a partition key?

987

---

What is a data manipulation language?

1024

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1039

---

What are the basic techniques of indexing?

1063

---

What are packages in pl sql and also explain its advantages?

1040

---

what is a database lock ? : Sql dba

1173

---

What is union, minus and interact commands?

1299

---

Explain the difference between triggers and constraints?

975

---

Can we use pl sql in mysql?

1013

---

Which data type is a composite type?

989

---

How do I kill a query in postgresql?

1129

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1064

---

Why stored procedure is better than query?

948

---