|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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. Latest Answer : Execute : It returns boolean valueExecuteQuery:it returns resultsetExecuteUpdate :It returns integer ... Read Answers (4) | Asked by : srinivas View Question | Asked by : Vikram Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted Latest Answer : Co-related sub-query:- The main differencre between subquery and co-related subquery is that in subquery child query is executed first n then parent,but in co-related subquery main query is executed first(even though parenthesis are present) and then ... 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? Latest Answer : Pre-query trigger fires before the query excutes and fires once while you try to query. With the help of this trigger you can modify the where clause part dynamically. Post-query fires after query excutes. So it fires for every row fetched. If the query ... Read Answers (1) | Asked by : sandeep I want to tune the sql query written on two field change peoplecode please help me to tune the query I want to tune the sql query written on two field change peoplecode please help me to tune the query as it is very urgent i am pasting the query isAMT1 = 0;AMT2 = 0;AMT3 = 0;AMT4 = 0;If All(DATE_FROM) Then &FROM = " and asof_dt >= %DateIn(:ml_gul_40a_wrk.date_from)";End-If;If All(DATE_TO) Then &TO = " and asof_dt View Question | Asked by : snehal How can i sort data in Oracle Forms at runtime after executing the query for specified critirion? i used set_block_property but when click on Sort button it fetches all the data again from the base table.Thanks in advanceTasleem Read Answers (2) | Asked by : Tasleem
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
