Dear Sir,

Please help mw answering following questions

1.Under What circumstances VIEWS are updateable in ORACLE 2. Why Commit,rollback and other DML statements are not allowed in Database Triggers. 3. Can we write DML statements in Store Procedures and function.If no then why ? 4. What are the key features of Oracle financial.Why Oracle financial is different from other Oracle Versions.

Regards

Y. Jacab

-- Jacab (yjacab@yahoo.com), September 08, 2001

Answers

BECAUSE DATABASE TRIGGERS ONLY CAN DO DML ON TABLES, IN THE PAST THAT IS ORACLE2 NOW ORACLE 8 CAN DO EVRYTHING ,ALSO FINANCIAL IS DIFFERENT LIKE OTHER PACKAGES BECAUSE OF COMMERCIAL APPROACHING TO SOFTWARE WORLD BYE

-- fatih telli (fatihtelli@yahoo.com), January 16, 2002.

VIEWS ARE ATTATCHED TO TABLE TRIGGER ARE RALETED TO DATABASE

-- UTTAM LAKADE (UTTAMLAKADE@YAHOO.COM), January 16, 2002.

commit and rollback commands are to control the transactions and we cannot write a triggers on the commit and rollback. and from oracle 8i version a user can not only write the triggers on dml statement,but they can also write triggers at schema level and also at database level

-- dilip kumar (dskumar73@yahoo.com), May 24, 2002.

a user can perform all dml transactions on normal views,so that those changes can occur in the associated tables.

but there are some complexities are involved when a view is created with any group function or a view which is created on table joinings

-- dilip kumar (dskumar73@yahoo.com), May 24, 2002.

all the simple views i.e.any select statement without any group funtions or joing of tables is there,we can perform all dml operations on the view.

-- dilip kumar (dskumar73@yahoo.com), June 25, 2002.

fgry

-- sardar tariqmehmod (tariq9209030@yaho.com), August 06, 2002.

Tell me what is Functional Dependency, is it rlated to 3Normalization form ? if yes then how. wat is projection calculas. ?

-- Saurabh Dhall (dhallsaurabh@hotmail.com), June 17, 2003.

ediot

-- mon mon lathi jhata (moonmoon@yahoo.com), June 19, 2003.

1. The view should not left out any NOT Null Coloumn from the table. 2. It makes some unwanted jobs 3. Yes. You can.. But based on the sitution.

-- jerald (amirtha@hotmail.com), July 29, 2003.

Am trying to create a database in oracle 9i. When i run the script it gives me a messsage disconnection forced and terminates. When i check for the error in the trace file it shows that a file sql.bsq failed. What can i do to correct this file

-- geff rafraf (ovitag@yahoo.com), September 09, 2004.