Latest Answer: It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while the subquery is heighly selective, then you the ...
Latest Answer: -Â Â A cluster is a set of 2 or more machines (nodes) that share or coordinate resources to perform the same task. Â Â Â Â Â Â Â - A RAC database is 2 or more instances running on a set of clustered nodes, with all instances accessing a shared set of ...
Accept the sysdate in the following format(YYYYMMDD)and from this date you need to go back 24 months and print all the 24 months dates in ascending order.
Explain how Oracle 9i offers a comprehensive high performance infrastructure for e-business. What infrastructure here means?
Latest Answer: There are three types of conversions 1- TO_DATE2- TO_CHAR3- TO_NUMBERTO_DATE:use to convert charector into data by giving format mask.TO_CHAR:use to convert number into charecter, and date into charecterTO_NUMBER:use to convert cherector ...
Latest Answer: Crystal Report supports to create report from third party database, Oracle Report supports to create report from Oracle Database only. ...
Latest Answer: SQL Navigator, SQL Plus ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 Next >>
Go Top
