 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 Latest Answer : A Pl/SQl is Procedural language extension for SQl.U can do certain thingslike creating blocks,procedures,functions,triggers etc..A cursor is a private work area(or u can say it a place) where the query's will beanalysed ,executed and ... Read Answers (4) | Asked by : priyanka aoni Latest Answer : here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE(cursor_name, ’DELETE FROM ’||p_tab_name,DBMS_SQL.NATIVE ... Read Answers (5) | Asked by : Vinoth Latest Answer : Hi,I hope the difference is:execute() - returns boolean value (true implies that the query returns some Resultset, where false is not)executeUpdate() - returns integer value (the value implies number of rows affected)bye.. ... Read Answers (1) | Asked by : Jayakumar Latest Answer : IN->Equal to Any One in the List.ANY->Compares Value to Each Value Returned by the Sub Query.ALL->Compares Value To Every Value Returned by the Sub Query.For Example:IN:(Q):Display the Details of all the Employees Whose Salaries are ... Latest Answer : i in 9i is internet.g in 10g is grid. ... Latest Answer : The advanced type is varchar2 in latest versions.The simplest way to define is the char i.e. char(s): Fixed length character value of size sand the varchar2(s): Variable-length character value of maximum size sie. char(s) can enter only char type,
where ... Latest Answer : The Difference between post and commit are as follows:Post:In oracle we never find such command post.Commit:The changes will be made permenently from the redo log buffers to the redo log files. ... Read Answers (2) | Asked by : ramesh 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
