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 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?
Can a Revoke or alter user statement be executed on a Session to modify a user's role (set as default) or revoke a role based on whether the uesr logged into a defined list of valid applications versus SQL Plus? I want to set one role if the user connects via an appropriate app and set a readonly type role if the user connects with something else. This is needed to resolve an audit issue.
How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ?
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.
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 have problem with oracle when i migrate any application (develop in developer 6i)from Developer 6i(on ms window) to Oracle Developer Suite 10g(on ms window)then my form is open in Internet Explorer without any problem all fonts and screen size is ok, when i check this form on Linux and browser is netscape then my form is too small.I am also compile this form on Linux based Application Server 10g then check this form on Linux browser again form and font is too small. Please tell me what
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?
How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select?
How can I upgrade Oracle Database and Client 9.2.0.6 to 9.2.0.7? I downloaded the 9.2.0.7 patch, but when I login to SQL*Plus, it still shows both server and client to be 9.2.0.6.Where do I get the upgrade software?And how do I upgrade?
