HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single
Latest Answer : when query is based on condition we use where clause & there is no any aggregate functionwhen query is base on contion & aggregate function has to be use then we can usehaving clause. ...
Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a
Latest Answer : Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ...
Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while
Latest Answer : PROCEDURE ...
No. A function has to return a value,an OUT parameter cannot return a value.
Latest Answer : Yes ,function can return a value but it is not a good programming practice ...
Drop Procedure procedure_nameDrop Function function_name
Latest Answer : absolutely it will work ...
1,000,00
Latest Answer : Up to Oracle 10g the buffersize os an integer between 2,000 and 1,000,000; From Oracle 10g Release 2 the buffersize is unlimited ...
Latest Answer : i think you are wrong.we can write dml in both function and procedure. ...
In a table a column is having value like 'Steven Kovy'. without using concat() function and concatenate operator "||" how to display like 'Kovy Steven'
WE using Last_value()analytical function but the result do not match according to me?
