Answer Posted / sudipta santra

Yes, Krupananda, U r very right..I am explainning the trigger:

Create or replace trigger bri_tab_101_rec
before insert on table1
for each row

declare
usr_ins_excep exception;
begin
if :new.column4 is null then
raise usr_ins_exception;
end if;
exception
when usr_ins_excep
<< do exception code>>
rollback;
end;

What to do if the startbd.bat failed to start the xe instance?

1017

---

What is Java Pool in Oracle?

1094

---

What privilege is needed for a user to connect to oracle server?

942

---

What is recycle bin in Oracle?

1086

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1907

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1795

---

What privilege is needed for a user to create views in oracle?

981

---

What are the attributes of the cursor?

936

---

Explain the use of analyse option in exp command.

1067

---

How to retrieve data from an explicit cursor?

1009

---

What is an Oracle Instance?

1073

---

What are the uses of linked server and explain it in detail?

1004

---

How to list all tables in your schema?

992

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1912

---

Explain the use of file option in exp command.

1081

---