 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 Latest Answer : Never seen in oracle ... Read Answers (5) | Asked by : srinivas Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks Read Answers (2) | Asked by : vishnu 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 ... Is there a way/tool to automatically export data via forms. Kinda like Dataloader that is used to import data via forms? Read Answers (1) | Asked by : Jarred Johnson 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 Suppose if we have load some data from source files to data warehouse n after a few months if we again want to add some more data into same data warehouse, then how can we implement that? Read Answers (1) | Asked by : ramya
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1