APEX: Use CheckBoxes in APEX Report
Sometimes it is necessary to have a checkbox in the first row, in order to do something with the records (delete, update). In this case we can use the following…
APEX: Open as Excel
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:…
Oracle 10g: Get OS version
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
Linux: JDK SE6 Installation
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…
Linux: Tomcat 7 Installation
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…
MS-DOS: FTP Example
Create 2 files: GetMP3.BAT and getMP3.DAT. In GetMP3.BAT: ftp -n -i -s:getMP3.DAT and in getMP3.DAT: OPEN 192.168.131.50 1212USER NISTA11111BINARYHASHCD files\INLCD C:\incomingFTPMGET Products.txtbyeFTP switches:FTP [-v] [-d] [-i] [-n] [-g] [-s:filename] [-a]…
Visual Basic 6: Modify the Registry
How to modify the registry: Attribute VB_Name = "modRegistryChange"Option ExplicitPublic Declare Function RegOpenKeyEx Lib "Coredll" _ Alias "RegOpenKeyExW" _ (ByVal hKey As Long, _ ByVal lpSubKey As String, _ ByVal…
Visual Basic 6: Open a program using its default application
How to open a program using its default application: Private Declare Function ShellExecuteAny Lib "shell32.dll" Alias "ShellExecuteA" _(ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _ByVal…
Visual Basic 6: Simple ADO Connection
Using SQL Server connection: Dim cn As New ADODB.ConnectionDim rs As New ADODB.RecordsetPrivate Sub Command1_Click() cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; pwd=sales;Initial Catalog=Sellout;Data Source=ATLAS-LAPTOP\NISTA" cn.Open Dim TheString As String TheString…
MS Access: SQL Training
At the bottom of the database you will find a sample MS Access Database for training in SQL.It is supposed to be a food company. It has 5 salesmen.The invoices…