|
| 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 Latest Answer : Execute : It returns boolean valueExecuteQuery:it returns resultsetExecuteUpdate :It returns integer ... Read Answers (4) | 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 : 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 : You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P. ... Read Answers (3) | Asked by : ram Latest Answer : ANY and ALL are Multiple row operators.ANY - Greater than the MinimumALL - Greater than the maximum ... Latest Answer : i in 9i is internet.g in 10g is grid. ... Latest Answer : The char is a fixed-length character data type, the varchar is a variable-length character data type.Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column. Because varchar is a variable-length ... 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 ... Latest Answer : In layman terms,SQL is a language to query a database.SQL plus is an editor (provided with oracle) to write/execute sql commands. ... Read Answers (6) | Asked by : xyz
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
