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 ...
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 : here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE(cursor_name, ’DELETE FROM ’||p_tab_name,DBMS_SQL.NATIVE ...
I am creating one table in oracle. in database it is allocated some memory for that table. how can i know how much memory that table is holding in that database?
I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change?
How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ?
Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks
Latest Answer : Hi,The databse domain are the differenet types of database. Database domain can be Oracle, MS SQL Server, Sybase etc. It's depend on user on which database domain he can work better.Suppose if we select oracle there different domains are: Oracle ...
Hi all, I recently installed Oracle 9i database and Oracle forms6i in my system. I couldn't access database through forms.If i try to connect, "ORA 12203: TNS: unable to connect destination" error is occured.Can anybody resolve this problem?
Is there a way/tool to automatically export data via forms. Kinda like Dataloader that is used to import data via forms?
