Skip to content
SWKB.NET

Daily Archives: June 14, 2012

  1. Home>
  2. 2012>
  3. June>
  4. 14>
  5. Page 2

APEX: Open as Excel

  • Post author:admin
  • Post published:June 14, 2012
  • Post category:APEX: How To Examples
  • Post comments:0 Comments

A PL/SQL package can create an excel output, using the following technique:In your package APPS.XXMY_PKG, procedure HTML_OUTPUT: if n_is_excel = 1 then    --Set headers to create excel    OWA_UTIL.MIME_HEADER('application/ms-excel;',   FALSE);    HTP.P('content-disposition:…

Continue ReadingAPEX: Open as Excel

Oracle 10g: Get OS version

  • Post author:admin
  • Post published:June 14, 2012
  • Post category:Oracle DB: How To Examples
  • Post comments:0 Comments

With the following command you can get the OS version: SELECT DBMS_UTILITY.PORT_STRING FROM DUAL; e.g. IA64/HPUX 64.0.9.0.1

Continue ReadingOracle 10g: Get OS version

Linux: JDK SE6 Installation

  • Post author:admin
  • Post published:June 14, 2012
  • Post category:Linux-Unix: How To Examples
  • Post comments:0 Comments

Using RPM archive: mkdir /usr/local/javacp jdk-6u21-linux-i586-rpm.bin /usr/local/java/jdk.bincd /usr/local/javachmod +x jdk.bin./jdk.bin<agree with terms and conditions>the package is installed into /usr/javathe command rpm -i is executed automatically uppon the .rpm file that…

Continue ReadingLinux: JDK SE6 Installation

Linux: Tomcat 7 Installation

  • Post author:admin
  • Post published:June 14, 2012
  • Post category:Linux-Unix: How To Examples
  • Post comments:0 Comments

Installation: tar xvzf apache-tomcat-7.0.2.tar.gz -C /usr/tomcat7 cd /usr/tomcat7 mv * .. cd .. rm -rf apache-tomcat-7.0.2.tar.gz edit tomcat-users.xml and put: <role rolename="manager-gui"/> <user name="nista" password="kookoo" roles="admin,manager,manager-gui" /> Optional Step: change…

Continue ReadingLinux: Tomcat 7 Installation
  • Go to the previous page
  • 1
  • 2

Recent Posts

  • How to loop through Collection
  • HttpXsrfInterceptor and HttpXsrfCookieExtractor implementation example
  • Euromillions simulation
  • The birthday paradox
  • Java: Write to file
  • Tomcat: How to set encoding to unicode
  • Oracle PL/SQL: SYS_RefCursor to JSON
  • Oracle PL/SQL: Conditional Cursor
  • MySQL: Load data into table from file
  • Oracle DB: NUMBER data type

Recent Comments

    Categories

    • AJAX: How To Examples
    • Angular7: How To Examples
    • Apache
    • APEX: How To Examples
    • C++: How To Examples
    • Calculations
    • CSS: How To Examples
    • Google: How To Examples
    • Hibernate: How To examples
    • HTML: How To Examples
    • Java
    • Java: Ant
    • Java: Fundamentals
    • Java: How To Examples
    • Javascript: How To Examples
    • Joomla: Fundamentals
    • Joomla: How To Examples
    • Linux-Unix: How To Examples
    • MS-Access: How To Examples
    • MS-DOS: How To Examples
    • MySQL: How To Examples
    • News
    • Oracle
    • Oracle ADF: How To Examples
    • Oracle Apps: Fundamentals
    • Oracle Apps: Links
    • Oracle DB: Fundamentals
    • Oracle DB: How To Examples
    • Oracle DB: Links
    • Oracle OAF: How To Examples
    • Oracle PL/SQL: How To Examples
    • Oracle PL/SQL: Links
    • PHP: How To Examples
    • Siebel: How To Examples
    • SOAP
    • Tomcat
    • Various
    • VB6: How To Examples
    • WebLogic
    • Windows: How To Examples

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Copyright - OceanWP Theme by OceanWP