OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Triggers

Wed, 14 August 2002 12:18

Radha Manohar
Messages: 3
Registered: July 2002

Junior Member

Do database triggers get compiled during creation time or during execution time?

Wed, 14 August 2002 12:39

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

A trigger, like any PL/SQL stored code, is compiled at creation time and automatically recompiled (attempted) at execution time if invalid.

Sun, 18 August 2002 02:41

shailesh
Messages: 22
Registered: October 2000

Junior Member

Hi!
I am Shailesh
Pl let me know How to convert data from foxpro to oracle using solloder utility
pl write in detail
waiting for your reply

Thanks

Mon, 19 August 2002 05:08

Rick
Messages: 49
Registered: March 2000

Member

Write each table in Foxpro to a CSV file.
Create a sqlloader control file (.ctl) for each table.
Use sqlldr to load data into Oracle.

Previous Topic:	update a row in a view
Next Topic:	How can i find the % in some of string by like option and

Goto Forum:

]

Current Time: Tue Apr 23 07:48:09 CDT 2024