 Related Questions 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 : 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 ... 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 Latest Answer : SQL: 1.it is a language for communicating with the oracle server to access data 2.it is based on ANSI standered sql.3.can"t be abbreviated.4.uses fns to perform some formatting.5.do not have a continuation character.SQL* plus.1.recognises ... Read Answers (3) | Asked by : kavitha
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1