w3apex

  How to uninstall OBIEE 12c in Linux. Drop RCU Schemas. De-install software. Delete the Oracle Home Directory. Delete Domain and Application Data. Drop RCU Schemas. Go to RCU file which is placed in below installed folder. <Middleware_home>/oracle_common/bin Run the command ./rcu Click on next and select Drop Repository. Click on Next. Enter details. Advertisements REPORT THIS AD Click on Next Click OK and select schema prefix which you want to uninstall. Click on next then finish. De-install software: Go to  ORACLE_HOME /oui/bin which is generic path. Advertisements REPORT THIS AD Note : First we should uninstall BI related software then weblogic server(means FMW). Click on Uninstall. Advertisements   Advertisements REPORT THIS AD   Click on finish then run the deinstall again for weblogic. Advertisements REPORT THIS AD   Delete the Oracle Home Directory Manually /u01/app/oracle Rm –rf fmw Advertisements Reboot the machine. Start fresh installation ...

  Datatypes Limit Comments BFILE Maximum size: 4 GB Maximum size of a file name: 255 characters Maximum size of a directory name: 128 bytes Maximum number of open BFILEs: see Comments The maximum number of  BFILEs  is limited by the value of the  SESSION_MAX_OPEN_FILES  initialization parameter, which is itself limited by the maximum number of open files the operating system will allow. BLOB Maximum size: (4 GB - 1) *  DB_BLOCK_SIZE  initialization parameter (8 TB to 128 TB) The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000 Foot 1 ). CHAR Maximum size: 2000 bytes None CLOB Maximum size: (4 GB - 1) *  DB_BLOCK_SIZE  initialization parameter (8 TB to 128 TB) The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000 Foot 1 ). Literals (characters or numbers in SQL or PL/SQL) Maximum size: 4000 characters None LONG Maximum siz...

  Create Database link with MySQL Server in Oracle Create Database link with MySQL Server in Oracle In My Case, both MySQL and Oracle is installed on one system. Create the entry for MySQL setting in Windows System by opening ODBC Data Source in System DNS as follows — Go to the System tabl –> Press Add button –> Select MySQL drivers –> Put all necessary details as follows: 2. Configure the HS directory present in Oracle Home: Advertisements Report this ad Note: Name MySQL as SID is used as same as created in Window ODBC Data Source in System DNS: Go to directory: C:\Oracle\dbhomeXE\hs\admin Copy paste the initdg4odbc.ora file to new file as init<systemdnsname>.ora Example: initMySQL.ora Edit this file initMySQL.ora file and add following entries: HS_FDS_CONNECT_INFO = MySQL HS_FDS_TRACE_...

 https://www.youtube.com/watch?v=UQzRIv2ODK8

 https://www.youtube.com/watch?v=7Ecxah88SOQ

  i'm begineer developer in oracle ebs i'm using report builder and rtf (xml) template to build report can anyone help my i want to make 2 layout in 1 template (1 rtf file) and give condition with if, lower and like (in sql i'm use like) but is error i give this query in my rft template: <?if: lower(WORK_ORDER_TYPE) like 'breakdown'?>     <?start:body?>         my_template     <?end:body?> <?end if?>please help my for this problem thank you very much

  <?if: position() = 3?>  <?split-by-page-break:?> <?end if?> ---------------------------- <? if position() mod 3 = 0?> <?split-by-page-break:?> <?end if?>