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 ...
Latest Answer : Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info. ...
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.
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.
So what is up with Oracle sever cluster failover and the Thin Oracle driver on WebShphere 6.0?! We can't get it to work correctly. Must you use the thick driver for failover or is this a Websphere issue?
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?
Hai i have installed oracle 10g on my system.and it shows that Pro C has also been installed but i am not getting any access to PRO C i.e i am not getting PRO *C UI(user interface) .how to access or start PRO C UI. please help me out.also i installed Oracle HTTP server and oracle companion products on my system but but i am unable access HTML DB. on what port numnber it will be accessible .also need help how to access text file in oracle,pl/sqlplease helpits urgent.prabhash
Hi,Subject: Oracle Apps :Order Management PTO,ATO, CTO Currently i am working on PTO they have some PTO type of orders. They call it Custom Config. The Customer may want to order something that requires Picking and Assembling multiple items from Inventory. The example Ram has given below is representative of what they would do now in FACTS.In this example they put Lines 1.1, 2.1, and 3.1 on the Order. However, Line 3.1 is made up by combining lines 1.1 and 2.1They then release the order and it reserves
