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 : Never seen in oracle ...
Latest Answer : A Pl/SQl is Procedural language extension for SQl.U can do certain thingslike creating blocks,procedures,functions,triggers etc..A cursor is a private work area(or u can say it a place) where the query's will beanalysed ,executed and ...
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 : Hi,I hope the difference is:execute() - returns boolean value (true implies that the query returns some Resultset, where false is not)executeUpdate() - returns integer value (the value implies number of rows affected)bye.. ...
Latest Answer : IN->Equal to Any One in the List.ANY->Compares Value to Each Value Returned by the Sub Query.ALL->Compares Value To Every Value Returned by the Sub Query.For Example:IN:(Q):Display the Details of all the Employees Whose Salaries are ...
Latest Answer : i in 9i is internet.g in 10g is grid. ...
Latest Answer : Dual is a system defined table having one rows and one column. A person who has informed that it has virtual
existence is not proper. It has physical existence.Ex:SQL> select * from dual;D-XMeans a table having single row and columns.Regards,Deepak ...
Latest Answer : The advanced type is varchar2 in latest versions.The simplest way to define is the char i.e. char(s): Fixed length character value of size sand the varchar2(s): Variable-length character value of maximum size sie. char(s) can enter only char type,
where ...
