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 : Execute : It returns boolean valueExecuteQuery:it returns resultsetExecuteUpdate :It returns integer ...
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?
Latest Answer : DUAL is a table.That is owned by SYS user .It has a column name as dummy and it containts a row having a vale "X".The dual table is useful when u want to retun a value once only,the value that is not derived in from a table with ...
My table has duplicate values pls help me How can i delete those values For Ex: my table contains 200 rows in that 100 rows are duplicate values and i can i delete those 100 rows pls give me answerregardsmangaiah
I used oracle8i and report 6i. I want to print character mode report pagewise. e.g. in report there is 20 pages and I want to print out only 5 to 12 pages. How does it possible..? our application is web based so that we used apache as server and orarrp.exe for printing utility. Please give me answer about it as soon as possible. it's urgent.
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
Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted
