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 union and union all keyword in sql and what are their differences?

1098

---

How can I speed up sql query?

955

---

What is the use of <> sql?

970

---

What is the maximum size of sqlite database?

1101

---

What is the source code of a program?

1062

---

What are the basic techniques of indexing?

1057

---

How many columns should be in an index?

959

---

define join and explain different type of joins? : Sql dba

944

---

How do I turn a list into a table?

953

---

what are all the common sql function? : Sql dba

1054

---

What is a procedure in pl sql?

1206

---

How do we use distinct statement? What is its use?

1025

---

what is the difference between where clause and having clause? : Sql dba

992

---

What is sql indexing?

1005

---

How do you use collections in procedure to return the resultset?

2236

---