 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. 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 Read Answers (2) | Asked by : vishnu 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? Read Answers (1) | Asked by : Jarred Johnson Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Applications)Module HRMSeg - 000001,000002.Pls update on thisRegardsVenu Read Answers (1) | Asked by : venu Suppose if we have load some data from source files to data warehouse n after a few months if we again want to add some more data into same data warehouse, then how can we implement that? Read Answers (1) | Asked by : ramya Hi All I am very new D2K There are lots questions but not the basic questions like Diff in Data block, Normal Block. Diff in Call_forms, New_forms,Open_forms? Read Answers (1) | Asked by : Dhiren What are the new features of Oracle 10g over Oracle9i?. What are the possible steps to be taken care What are the new features of Oracle 10g over Oracle9i?. What are the possible steps to be taken care while migrating data from 9i to 10g ?If possible please list out all the differences between Oracle 9i And 10g. Read Answers (1) | Asked by : Ishwar Goudar
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
