Oracle Database 12 c Release 1 (12.1.0.2.0) Click on setup and run as 'Administator' Click Next Check on Configure a database and hit Next Click on Server Class and hit Next Click on Single Instance Database Installation and hit on Next Click on Advanced Installation and hit next Select English and hit next You will be enabled by default for enterprise edtion Click on Use Windows Built-in-Account Ignore the message and click on Yes and proceed to next window Change your desire path Click on Datawarehousing Give your Oracle SID Go to Character sets Click on Unicode (AL32UTF8) so that it will support all the language Hit Next Hit Next Give your Password for Oracle Database 12c Click Next to install Oracle Database 12c It will Start Installation Give Ok for Oracle Database 12c Installation Congrats.. You completed Oracle Database 12c Installation
Posts
I have recevied Exceeded configured maximum number of allowed output prompts, sections, rows, or columns Error during building pivot view. Screenshot of my error Solution: Go to instanceconfig file from below location: E:\bi119\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 Search for the below lines <ODBC> <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--> <ResultRowLimit>65000</ResultRowLimit> </ODBC> Change as Below <ODBC> <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--> <ResultRowLimit>999999</ResultRowLimit> </ODBC> Find the below lines <Pivot> <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--> <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDel...
In many case we are suppose to add one additonal column in our table and insert data from another column from same table. In my case, I want to add month column which store only month and year in yyyymm format ALTER TABLE ebiz1 ADD mont column_type NULL Insert into column from same table in Oracle From the above syntax we will get additonal column in my table ebiz1. After the column is created I need to use UPDATE Statement as below. UPDATE ebiz1 SET mont= to_number(to_char(gl_date, 'yyyymm')) From the Above statement I just copy gl_date column data into month column in yyyymm format