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 the syntax used for partition in tsql? : Transact sql

543

---

what happens if null values are involved in expressions? : Sql dba

572

---

what is heap table? : Sql dba

612

---

What is use of term?

626

---

What does truncate mean in sql?

538

---

---

What is package in pl sql with an examples?

551

---

Is it possible to create the following trigger: before or after update trigger for each row?

724

---

What does sign mean sql?

573

---

Is it possible to create startup or shutdown trigger for on-schema?

590

---

Does oracle use sql?

519

---

Explain ttitle and btitle.

674

---

What are the types of subqueries?

575

---

Why do we need databases?

571

---

What are predefined functions in sql?

538

---

How many tables can you join in sql?

535

---