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

In pl/sql, what is bulk binding, and when/how would it help performance?

629

---

what is user defined functions? : Sql dba

641

---

What information is needed to connect sql*plus an oracle server?

675

---

Explain locks? : Transact sql

655

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

650

---

---

How to convert comma separated string to array in pl/sql?

698

---

What is online transaction processing (oltp)?

684

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1024

---

What are the types of variable use in pl sql?

651

---

how to concatenate two character strings? : Sql dba

639

---

Differentiate between sga and pga.

787

---

Explain the purpose of %type and %rowtype data types with the example?

642

---

Can we use the cursor's to create the collection in PL/SQL?

589

---

What are sql ddl commands?

635

---

Can we enter data in a table in design view?

598

---