Latest Answer: Cursor is a private SQL area.. its a temporary buffer used to hold the
transactional data on it n used to manipulate multiple rows through PL/SQL block
statements.
Temporary table can hold the records permanently and we can do DML operations
on ...
Latest Answer: The PL/SQL Blocks are 2 types1. Ananymous Block2. Named Block1. Ananymous Block means with out any name.Ex:- DeclareBeginExceptionEnd.2. Names Block are Procedures/Functions/TriggersOk..... CheersRav'i'ndra ...
What happens if we don't write any thing between BEGIN and END in a procedure? If it show error than how can we execute this code error free?
Latest Answer: You must be speaking about PLS_INTEGER. PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER which uses library arithmetic. As such PLS_INTEGER is somewhat faster than BINARY_INTEGER. Also BINARY_INTEGER has subtypes. I don't think PLS_INTEGER ...
Latest Answer: desc has two meanings and depends on the usage.when used in sql plus as in the below stt.desc ;it is taken as a sqlplus keyword and describes the table, dispalying column, constraints and data type for each column.an alternative is when ...
Latest Answer: In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping construct strategy for storing and retrieving. In terms of performance comparison while retrieving data from both strictures hash join is best in terms ...
what is the differences between it.
Latest Answer: Rule Based Optimization is an older technique which is used for optimization of queries but follows a fixed rule or strategy for achieving the same. But in contrast cost Based Optimization is a later new technique which is also used for optimization of ...
Latest Answer: Also as mentioned by our friend rowid is a unique hexadecimal format integer which takes up the representation as below File: Block: Row One can retrieve rowid by using the statement as below: ...
Latest Answer: select max([columnName]-4) from tableName ...
Latest Answer: you can use SYSDATE oracle.lv_today := sysdate;or select sysdate into lv_today from dual;both the statements assign sysdate to lv_today ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
