 Related Questions No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.But the DML statements are should be saved by giving the commit statement after execute the query Latest Answer : DDL is Data Definition Language. DDL commands work on the table directly or on the table structure. By default it has auto commit.DML is Data Manipulation language that affects the data present in the table. Any addition or modification of data has to ... Read Answers (4) | Asked by : srinivasan I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible. Latest Answer : what harsha said is right.in addition to the above reports there are 3 more triggers1. VALIDATION TRIGGERS2.FORMAT TRIGGERS3.ACTION TRIGGERS ... Read Answers (2) | Asked by : megh Latest Answer : there are many tips!1) inside a cursor never perform an other sql or call a function performing an sql, join that table better to the cursor body.2) perform bulk operations3) avoid in (subselect) better join this table to the master select4) avoid ... Latest Answer : Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form trigger. Depending on your criteria, you can use form ... Latest Answer : Yes we can use procedure in trigger...but not trigger in Procedure.ThanksAmol Bawane ... Read Answers (2) | Asked by : suguna Latest Answer : Hi,Basically we used five types of triggers in oracle reports.before parameter formafter parameter formbefore reportbetween pagesafter reportRegardsPawan Ahuja ... find it imm... Latest Answer : For the machine point of view data is stored in binary format.But if we say from database point of view it is stored in unicode format. ... Where is the configuration file is stored in Oracle 9i and 10g In D2K How to change the label text of a boilerplate object dynamically, using conditional triggers?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
