 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 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. View Question | Asked by : T Landon How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ? 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 ... Read Answers (1) | Asked by : Siraj Ali 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 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 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? View Question | Asked by : valaykothari
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
