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

Why is normalization important?

536

---

How many scalar data types are supported in pl/sql?

518

---

What is the difference between inner join and natural join?

508

---

What do you mean by table in sql?

524

---

How do you exit in sql?

587

---

---

What is equi join in sql?

608

---

What is sorting in sql?

503

---

Explain the components of sql?

587

---

Explain the commit statement.

611

---

What is the difference between an inner and outer join?

537

---

Why do we create stored procedures & functions in pl/sql and how are they different?

500

---

What is sql not null constraint?

600

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

529

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1132

---

What is cursor in pl sql?

574

---