Oracle Server: 8.0.5
Operating System: Windows NT
Mail Server: MS Outlook.
I am trying to send email from Oracle. I can successfully send email from Oracle Alert using MS Outlook. Does anyone have experience to send email from procedures or triggers by calling MS Outlook? I prefer to use procedure or trigger to send mail.
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…