SQL
Install demo schemas in oracle database12c
This tutorial shows how to deploy demo schemas in oracle database 12c First, we will begin by creating a new pluggable database12c on witch demo schemas should be deployed. Open your start meu and search for dbca.bat, it is in %ORACLE_HOME%BIN Run dbca.bat as admisitrator Choose Manage pluggable databases Create a pluggable database Select a […]
sql-aggregate functions
Using Rollup, Cube, Grouping and Grouping Sets. Rollup – operation: It is a sub-class of group by-clause, aggregating the select statement’s output. For our test, the promotions – table in sh schema is used, SELECT P.PROMO_CATEGORY, P.PROMO_END_DATE, P.PROMO_COST FROM PROMOTIONS P ORDER BY P.PROMO_CATEGORY; PROMO_CATEGORY […]
About Me
Senior oracle DBA/Developer | 9X OCI Certified | OCP | OCE Sql Certified Expert
