Latest

he tutorial shows how to protect Excel sheet with or without passwords. It also explains how to unlock Excel spreadsheet without password if you forgot or misplaced it. …

Long time VirtualBox users will know that VirtualBox doesn’t support resizing virtual hard drive via its settings. In one of our earlier posts, we discusse Source: Resize Hard Disk Operation For This Format Is Not Implemented Yet …

Once a domain is added and verified into Office 365 there is a default domain appended to every tenant. You can view your tenant setup by going to Setup and Domains within the admin portal. Typically, when you do the registration most admins …

case Source: networking – What DNS servers am I using? – Unix & Linux Stack Exchange …

After installing CentOS you will wan’t to configure IP address. CentOS is mostly used as Server. So you will want to give it a static IP address. By default CentOS interface is configured to receive IP from DHCP server. Here …

…

/*** Remove Footer ***/ .bottom-nav { display: none; } …

Written by Rachel Bauer This page shows you how to login to the Hitron-Technologies BVW-3653 router. Find Your Hitron-Technologies BVW-3653 Router IP Address We need to know the Internal IP Address of your Hitron-Technologies BVW-3653 router before we can login to …

As these wads where hard enough to get going on older Windows XP & 7, now with Windows 10 its harder. With the addition of updated or new Doom Source ports I wanted to get these wads play nice on …

vboxmanage-modifyvm-other Source: Chapter 8. VBoxManage …

Source: How to load the classic workspace in AutoCAD Architecture or AutoCAD MEP | AutoCAD Architecture | Autodesk Knowledge Network …

Describes how to resize a linux virtualbox vdi drive under windows host Source: How to resize a virtualbox VDI disk under windows | derekmolloy.ie …

Copy the ISO file into the VM (i.e. Downloads folder) and create a dir to use to mount the ISO to: mkdir -p /var/OSimage/OL6.9_x86_64 Mount the directory with ISO file to a path: mount -o loop, ro /home/oracle/Downloads/CentOS-6.9-x86_64-bin-DVD1.iso /var/OSimage/OL6.9_x86_64/ Go …

Source: menus – Walker_Nav_Menu exeption – WordPress Development Stack Exchange …

Source: Computer wakes up from Sleep mode immediately – Microsoft Community …

Copyright © bab.la …

DocX is a compressed zip container file. Make a copy of the original docx file. If you unzip it, there is a subfolder named word with a file named settings.xml. You can open settings.xml with a plain text editor.Within that …

How to Remove a Password Now for the difficult part, although it’s really quite straightforward once you know what you’re doing. First, we’re going to need to download a hex editor. If you don’t have one already, HxD is a …

System corruption is the worst that could happen to your Windows installation. We show you how to get Windows 10 back on track when suffering from BSODs, driver errors, or other unexplained issues. …

I see several people are having a similar issue and none of the posted solutions I’ve tried have worked for me. I’ve deleted antiviruses, run the SFC, installed updates, rebooted several times. Source: Windows 10 file explorer not responding – …

Windows Genuine Advantage (WGA for short) is a Windows Update component rolled out to XP users long after XP was released. It is intended to validate your …

/* WPML Current Menu */.current-language a { color: #00b5b5 !important; } Source: Color for current language and display languages – WPML …

First: Install MoreLangs First What you need Computer (Windows Only) Usb cable Connect you Phone to Computer(PC) (Windows Only)   Step 1. …

Learn how you can add a new Social Icon in Divi WordPress Theme From Elegant Themes. Source: How To Add a Social Icon in Divi WordPress Theme From Elegant Themes …

My son and I went through rather painful ordeal with this Event 11 that Windows quietly generates. It took us few weeks to fully work out why Windows suddenly started hanging, misbehaving or even c Source: Solved: The driver detected …

Source: Hosted OpenEMR – OpenEMR Project Wiki …

How to Remove Locky Files Virus? A vicious ransomware named Locky which demands payment through a Tor website – all Marvel fans should be quite impressed right now. Unfortunately, this wordplay is the first and last fun experience that the …

Set up a virtual private network in a few simple steps. Source: How to Set Up VPN in Windows 7 | PCWorld …

Source: Google Docs — Support — WordPress.com …

…

PROBLEM Consider the following scenario. You upgraded to Office 2016 on your computer. When you use OneDrive for Business, your libraries stop syncing and the icon overlays don’t appear on synchronized files and folders. SOLUTION To resolve this issue, perform these …

Outlook 2013’s IMAP implementation has changed quite dramatically when compared to previous versions of Outlook. While it does do a better job at getting the special folders correct more often, there sadly is no more option to change it manually …

To install a Fortran compiler (gFortran) to be used within the Code::Blocks IDE editor: Go to http://www.codeblocks.org/downloads Click on “Download the binary release” Click on “Windows 2000/XP/Vista/7//8” Click on “codeblocks-13.12mingw-setup.exe” to download from SourceForge.net Once downloaded (~100MB), install Code::Blocks IDE Full …

To add a Data Source from JDeveloper: View > Application Server Navigator Application Servers > IntegratedWebLogicServer R-click > Launch Administrative Console… -that should be i.e. like “http://127.0.0.1:7101/console/login/LoginForm.jsp” Login with user/password From Domain Structure open Services > select Data Sources New …

You receive the following error when you try to delete a local user account in Windows XP Home: Remove Domain NameComputer Name. Error 1377: The specified account name is not a member of the local group. Error removing Domain NameComputer …

You can check the health of your hard disk by using a command in Windows (S.M.A.R.T.). Start a cmd window wmic diskdrive get status This should output the following result: status ok ok   …

Prerequisites: a notepad (I recommend: notepad++) some HTML knowledge Start a simple HTML page and add the following as the main structure:<head> <title>Backup Reminder</title> <HTA:APPLICATION APPLICATIONNAME=”Backup Reminder” ID=”myware” VERSION=”1.0″ CAPTION=”yes” BORDER=”normal” SYSTEMMENU=”yes” MAXIMIZEBUTTON=”no” MINIMIZEBUTTON=”no” ICON=”gumware.ico” SCROLL=”no” SCROLLFLAT=”yes” SINGLEINSTANCE=”yes” CONTEXTMENU=”yes”/><style> img{border: …

Repartition and format the USB: Primary volume, 4k cluster size (default), FAT32 format. XBoot requires dot.NET Framework 4.0 installed on the system it will be run off Download a copy of XBoot 1.0 beta 14 and run it, not install …

1. Type the following in the address bar: about:config 2. In the search field type: keyword Result: keyword.URL keyword.enabled 3. Double-click “keyword.enabled” to be set to false. 4. Double-click the “keyword.URL” to set your source search engine: Bing: http://www.bing.com/search?q   …

Create a sequence (i.e. “tmp” starting with 10001) to be used in statements: CREATE SEQUENCE TMP START WITH 10001 MAXVALUE 9999999999999999999999 MINVALUE 1 Enter the following in a DB-Tool editor: begin FOR Lcntr IN 1..10000 LOOP insert into customer (surname, …

Firstly, insert your USB  (WARNING: the following steps will erase ALL DATA on selected USB!!). Open a cmd prompt and type “diskpart” to start the partitioning program: list disk # <– to list the disks on the system # Disk …

If you get the following or similar error: OC4J – (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig (jms.xml) You may need to delete all contents within the “persistence” folder: jdev10.1.3.5.adfjdevsystemoracle.j2ee.10.1.3.43.6embedded-oc4jpersistence …

Lenovo S10 : Lenovo OneKey Rescue System v7.0 Press the “OneKey Recovery” button on right side of display (like and upside-down U) Click on “OneKey Recovery” icon on screen Choose “Restore from initial backup” and click “Next” WARNING: ALL YOUR DATA/PARTITIONS …

Older VB application built on VB 5 or 6 may not work properly under the newer versions of Windows Vista, 7 or 8. The app may even require specific dll or other file to be registered on the system. You …

The reason you get some numbers next to file names of JDeveloper (or IPs on project names) is because subversioning is enable in your JDeveloper’s options. To disable and continue to use your external subversioning system do as follows: From …

This is what you need to do if your Sage Accounts application has been corrupt and you can’t open it: Save your data files directory (SageAccounts) Uninstall/completely remove the Sage installation Re-install Sage Line 50 v9.x Start Sage and complete …

Login to the database and execute the following: select * from v$version; –OR: select * from product_component_version; Result: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production PL/SQL Release 11.1.0.7.0 – Production CORE    11.1.0.7.0    Production TNS for 64-bit Windows: …

1. Install Visual Basic 6.0 (as Administrator) Select custom install as follows: Microsoft VB 6.0 Active X Data Access Graphics 2. Skip MSDN and all other install options (Source Safe, VC++, etc). 3. Uncheck registration and complete the setup. 4. …

Creating a System Repair Disc can solve you a few boot problems encountered with Windows 7. Note the OS type (x32 or x64 bit) Insert an empty DVD into your drive Start > Programs > Maintenance > Create a System …

Note: Some business-line PCs may come with pre-installed non Windows OS like FreeDOS. These systems most probably use Linux as there main boot system and this is why a typical Windows installation may not boot properly in some cases. Case: …

Create a batch file and enter the following: @echo off echo. echo. echo. :: set varables set FRMCMP=c:OracleMiddlewareas_1binfrmcmp.exe set FORMS_DIR=c:UsersAdministratorjavaprojectsDOMAIN_NAMEFormsReportsSystemForms set USER_PATH=c:UsersAdministrator set DEST=c:FORM_EXECUTABLES :: get input from console set /p choice=  Type the form name (w/o extension): set …

FUNCTION GET_FILE_NAME (or CLIENT_GET_FILE_NAME) (directory_name   VARCHAR2, file_name        VARCHAR2, file_filter      VARCHAR2, message          VARCHAR2, dialog_type      NUMBER, select_file      BOOLEAN; Params descriptions directory_name = Specifies the name of the directory containing the file you want to open. The default value is NULL. If directory_name …

Before you go into any development download and try the Webutil Demo first and see how that works in your environment! 1. Add the Webutil library to the form 2. Create a Data Block “COMMAND_LINE” 3. Create a new layout with …

You need to open an Oracle Forms 11g url, which in turn will open a new IE window -but you want to somehow get rid of the first IE window. 1. Create a new html file i.e. “openWindow.html”, under %ORACLE_HOME%formsjava …

You will need to modify your main entry form procedure and place some javascript code to close the browser window. 1. Create a new html file i.e. “closeWindow.html”, under %ORACLE_HOME%formsjava as below: <html> <body onload=”closeWindow()”> <script type=”text/javascript”> function closeWindow() { …

The following are supported regular expression operators for use in PL/SQL Developer by Allround Automations:a+ One or more occurrences of a a* Zero or more occurences of a a? Zero or one (i.e. optional) occurence of a a{n} Exactly n …

Create a function in the DB to retrive the java properties: CREATE OR REPLACE FUNCTION get_java_property(prop IN VARCHAR2) RETURN VARCHAR2 IS LANGUAGE JAVA name ‘java.lang.System.getProperty(java.lang.String) return java.lang.String’; Then, run the following command to output the Java version: SELECT get_java_property(‘java.version’) FROM …

Notes: – frmwebutil.jar already exists/is signed on 11g – tested with JRE version 1.6.0_25, webutil 1.0.6, jacob 1.10.1_b17 – windows 7, 32bit 1. Download webutil_1.0.6  (or from oracle’s index page) and jacob_1.10.1_b17 (or from project page) jar files. 2. Copy …

Write the following in a batch file and say the input was “andreas”: @echo off echo == Capture Input === set server=192.168.1.12 SET /P Choice=Type your Username and press Enter: echo Logging on to %server% with %choice%… Output: Logging …

Your SVN project should already be checked out. Enter the following in a batch file (.bat): @echo off echo. echo. :: The two lines below should be changed to suit your system. set SOURCE=C:projectsmy_svn_project set SVN=C:Program FilesTortoiseSVNbin echo. echo. …

Enter the following script and save it as a .vbs file: Set obj = CreateObject(“WScript.Shell”) obj.run”cmd” WScript.Sleep 500 obj.SendKeys”telnet your.ip.add.ress” obj.SendKeys(“{Enter}”) WScript.Sleep 500 obj.SendKeys”username”  ‘telnet username obj.SendKeys(“{Enter}”) WScript.Sleep 500 obj.SendKeys”password”  ‘telnet password obj.SendKeys(“{Enter}”) WScript.Sleep 500 …

How would the typical Windows Explorer compare to alternative file manager Total Commander:  Total Commander  Windows Explorer  Two pane window view Instant view of source and destination and no scrolling via a tree-view or loose any open path Full Keyboard …

C:OracleMiddlewareuser_projectsdomains<domain_name>configfmwconfigserversWLS_FORMSapplicationsformsapp_11.1.1configformsweb.cfg … lookandfeel=Generic … lookAndFeel=windows The change is instant, no need to reload the services. …

Download and install Oracle Database XE 11.2g Download Oracle Application Express 4.1 (APEX) Tip: In case you get an ORA-12560 error, your database listener has not started. Either start it by running “c:oraclexeapporacleproduct11.2.0serverbinStartDB.bat” or use  the “Start DB” shortcut from …

Simple way Copy your images to: c:OracleMiddlewareas_1formsjava Notes: – Icon files may not be supported. – In case of a Java security issue when using gif images, you will need to create a jar file and sign it with oracles …

When you move or copy a WebLogic 11g environment setup as a VM from one host PC to another, you will encounter various IP connection problems (may also be needed if you have problems debugging forms). To help make a …

Whether you have an oracle home setup or not: * copy/setup PL/SQL Developer or TOAD to your system * copy/setup Oracle Instantclient to your system * add a System PATH Variable for Instantclient i.e. c:usersoracleinstantclient -if this is a 2nd …

Find a “tail” cmd-line program like “tail-f” or “WinTail” (gui) and load to your c: path. I’ve been using tail for windows by TriSun Software Inc. and does the job fine and its FREE! Typical usage: c:tail.exe -f c:myfile.log #log …

In most cases to utilise your vm-disk it needs to be dynamic. So if you have preallocated space for your disk then convert it to a dynamic one. # make the vm-disk from pre-alloc. to dynamic (-t 0 = dynam. …

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows XP 32bit reqs: WinXp SP2 or later, 1GB Memory, time: Oracle Weblogic: 10 min, Fusion Middleware: 40 min setup, 50 min config Download Weblogic Server 10.1.3.2 (11g) from here Tip: look …

Open the Run dialog and enter the following: control userpasswords2 The User Accounts dialogue opens up and you should select the option: Users must enter a user name and password to use this computer …

To tail a file use: tail -f -v Name_of_file_*.log …

From within PL/SQL Developer: Tools > Preferences, Under Oracle > Connection * Oracle Home… (point to where tnsnames.ora file is, under the Oracle Client Installation) c:Users<username>oracleinstantclientnetworkadmin * OCI Library… (point to where the OCI library is placed of the same …

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows 7 64bit reqs: Win7 x64, 1GB Memory, Administrator time: Oracle Weblogic: 5 min, Fusion Middleware: 23 min setup, 16 min config Download Java JDK 6u25 x64 (jdk-6u25-windows-x64.exe) Download Weblogic Server 10.1.3.2 …

Trace and Alert log files Root ‘log dump’ location: select value from v$parameter where name = ‘background_dump_dest’; /u01/app/oracle/diag/rdbms/db_name/trace Find the trace file path of current session use the following PL/SQL snippet: select u_dump.value || ‘/’ || db_name.value || ‘_ora_’ || …

Create the Java class public class Hello2 { public static String hello() { return “Hello World.”; } public static String hello(String name) { return “Hello ” + name + “.”; } public static void main(String args) { System.out.println(Hello2.hello()); System.out.println(Hello2.hello(“Java”)); } …

Login to where the Oracle DB is installed and vi as root vi /etc/oratab Edit the file, find and set the lines as follows: orcl:/u01/app/oracle/product/10.2.0/db_1:N vi cmd to type Insert key orcl:/u01/app/oracle/product/10.2.0/db_1:Y vi cmd Esc to exit editing vi cmd …

Login to the server which you have the DB installed on sqlplus /nolog #login to SQL*Plus console From SQL*Plus console: conn user/pass as sysdba var ohp varchar2(100);  –set a variable ‘ohp’ exec dbms_system.get_env(‘ORACLE_HOME’, &#58ohp) ; –call the get_env system-procedure print …

Create the Servlet Right-click on the package you need it for and select New… From the new gallery select Web-Tier > Servlets on the left and on the right select HTTP Servlet Click Next and give the Servlet: Class name …

Case: You need a new field on a table in the DB and need to use it on a jspx page in ADF 10g. After you have added the column in the relevant table in the DB, turn to the …

Level: Advanced Prerequisits: Model, DataControl and Backing-bean class 1. Find the page you need to add the field to i.e. CreateNewEmp.jspx 2. In the body > form of the jsp(x) page you should typically have a “panelForm” where fields are …

Check or change the default port numbers by editing the file (in VI): vi $ORACLE_HOME/install/portlist.ini …

After QEMU Manager 7.0 installation: Create a new VM from Qemu Manager Type a name for the new VM > Next Select, “do not use an image” > Next Output, “QEMU Manager Default” > Finish Then under the “Advanced tab …

System.out.println(): Netbeans: sout -> Tab Eclipse: syso -> Ctrl + Space JDeveloper: sop -> Ctrl + Enter System.err.println(): JDeveloper: sep -> Ctrl + Enter some credits: Java-Servlet-Jsp Blog …

Once you have XMing installed on windows do as follows: Set xming shorcut target as: ”C:Program Files (x86)XmingXming.exe” :0 -clipboard -multiwindow :0 sets the x,y stating point of the displayed window Start xming (you should see a xming icon next …

declare counter1 number := 0; counter2 number := 0; cursor cur_t is SELECT * from emp where e_name = \’Ptere\’; –set cursor, a select statement rec_t emp%rowtype; –defines this is a row from the database begin counter1 := 0; counter2 …

The following function will find any text matching the variable set within the procedure. (the output will display on screen -dbms_output) To execute: <SQL> execute update_found_records_proc; We could also add a parameter on calling the procedure as: CREATE OR REPLACE …

The following function will find any text matching the arguments given at command line. (output may not display on screen, but data will be inserted in the relevant table) To execute: select find_in_schema(‘ABC_553’) from dual; Credit:: Rene Nyffenneger on Oracle …

The following configuration should fix problems between tnsname, the hosts file and browser: tnsnames.ora (file) DBNAME_DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.98)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORADB1) ) ) DBNAME_PRD= (DESCRIPTION …

How to add a printer port mapped to a shared printer (most useful windows when it gets stubburn not installing the drivers): 1. Add Printer 2. Create New Port: Local Port 3. Enter Port Name: \\serverprintShareName 4. Next: use Windows …

You want to the following report output (ProdA and ProdB are within same column): Prod-Id | A | B | Subtotals 123 | 4  | 3 | 7 124 | 2 | 5 | 7 Columns: prod_id, prod_code, prod_type Group …

To re-create the lost Show Desktop shortcut on previous versions of Windows and now set to the far right of the screen, follow these instructions: Create a text file and enter the following: Command=2 IconFile=explorer.exe,3 Command=ToggleDesktop Save this …

Making SFTP connection via Total Commander: Option A, simple SFTP: download this plugin and install in TC add “sftp” dir under “pluginswfx” within TC copy the contents of the downloaded plugin to the new sftp dir from TC-options > plugins …

To check if  a Solaris machine has ftp enabled: inetadm | grep ftp #check the status inetadm -e ftp #enable inetadm -d ftp #disable …may also try: /usr/sbin/svcadm enable ftp /usr/sbin/svcadm disable ftp …

Say we have two tables: tab1  tab2 1          2 2         3 4         4 5 select t1.col1, t2.col2 from tab1 t1, tab2 t2 where t1.col1 = t2.col2(+) –pl/sql –Informix SQL: …from tab1 t1, outer tab2 t2 Result: t1 t2 1   – …

To install Midnight-Commander (MC) in Linux: wget http://www.midnight-commander.org/downloads/mc-4.7.5.2.tar.gz tar -zxvf mc-4.7.5.2.tar.gz cd mc-4.7.5.2 ./configure make make install #to run Midnight commander use: mc Notes: – if link don’t work look for an updated link – may need to install …

Create a “New Line” within a PL/SQL formula, use the following: /* Function to calculate the retirement date of a person based on person’s date of birth Parameter: p_birthdate, date Returns: ret_date, date */ CREATE OR REPLACE FUNCTION get_retire_date(p_birthdate IN …

Limiting access of an FM user. Set a variable and get the account name Set Variable From the script where you want the set user limitation: Perform Script //the script created in step 1 If Perform Script …

To let TotalCmd read the settings file from within itself: enter the following under section of the wincmd.ini file: UseIniInProgramDir=7 Save and copy wincmd.ini file to the program dir (if needed) …

To deploy a java/ADF app on an Oracle Application Server (10.1.3.1) and handle the datasources from there: After generating the ear and war files from within JDeveloper… Login to OAS Cluster Topology > OC4J-instance > Administration > JDBC Resources Firstly …

To start the Oracle Enterprise Manager do: 1. Log in <oracle_user>/<password> 2. Start-up the instance cd $ORACLE_HOME/opmn/bin opmnctl startall #start all services opmnctl status #view the services active/down opmnctl status -l #view statuses and ports used 3. Start em console ./emctl …

Oracle Application Server 10g Release 3 (10.1.3) installation on CentOS 5.5 (2.6.18-194.el5): Using: rpm > install packages, vi > editing, cpio, unzip > unpack archives Download and extract the OAS Suite cpio to i.e. /tmp/orainstall Check that the following packages …

Prerequisites: Import: Oracle DB setup with default DB the username that has access to the import DB Remember to set the character set if importing Unicode Import/Export: ip-address, SID, user/pass (sysDBA) …

Commands to create or extract cpio files in Linux. To create a cpio archive from a list of files: ls | cpio -ov > nameOfArchive.cpio usage: ls #to list the files to pack | #pipe to cpio o #create pack …

How to share a Linux folder using Samba for Windows access: (procedure using CENTOS networked on a Windows 7) System > Administration > Server Settings > Samba Preferences > Server Settings Basic tab: Workgroup = YourLocalWorkgroup Description = anything Security …

If you get an error message trying to start JMS-Server in JDeveloper 10.1.3.5 like: (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig Firstly check whether the port (default 9127) is not used/locked by other …

JDeveloper picks-up the default locale language from the OS. To change this and force JDev to a specific language: Open JDEV_HOME/jdev/bin/jdev.conf Add the following lines for English: AddVMOption -Duser.language=en AddVMOption -Duser.country=US This will show all warnings and message details in …

Navigation: cd /usr/local/i-net crystal-clear #use (backslash) to replace space in path ls #list dirs/files of current path, normal column-view dir #dos dir /q /a:r|h|s #to list dirs and files with attributes and owners dir /-n #to list dirs and …

Example: If I have a HistoryPage.jspx has a table which displays a list of the History records. This means -whenever the Dept. creates a new Decision, it is added to the decisions table. If we look at the config-faces.xml diagram …

Starting an Oracle Database and EM console (10g) login/su as the user who installed the oracle software (i.e. oracle) wins: set ORACLE_SID=sid_name  #the name SID given when creating database linx: export ORACLE_SID=sid_name sqlplus /nolog #just log onto the sqlplus console …

To run both versions of Office 2002/3 and Office 2007 on same machine: Set the file-types to open with relative version of Office: .doc, .docx, etc. (i.e. set .doc to open with word 2002 and .docx with 2007) Open Regedit …

To move a JDeveloper folder to a new location/machine: First find and edit the following files to the new path: path_to_new_jdev_root_folderjdevsystemoracle.j2ee.10.1.3.42.70embedded-oc4jconfigserver.xml Change all the paths referencing the old JDeveloper folder with the new path i.e. old path is: c:jdev_10.1.3.4 and …

The following snippet finds all duplicates in a table and then separates them: SELECT ID, LastName, FirstName FROM (SELECT ID, LastName, FirstName, RANK() OVER(PARTITION BY LastName, FirstName ORDER BY ID) AS SeqNumber FROM Customers) WHERE SeqNumber > 1; RANK() …

Exception handling is followed after an sql command, using ‘Exception’ i.e.: begin DELETE FROM TABLE1 t1 WHERE t1.table_id = variable1; EXCEPTION WHEN OTHERS THEN INSERT INTO ERR_DELETE (table_id, description) VALUES (t1.table_id, variable1); end; …

To enable output to console window in Oracle SQL Developer (as of 2.1.1.64) From the menu go to: View > Dbms Output From the new window (popped-up in the log area) click on the plus sign to enable output Enter …

SELECT emp, COUNT(emp) AS NumOccurrences FROM users GROUP BY emp HAVING ( COUNT(emp) > 1 ) also, find only one record: SELECT emp FROM users GROUP BY emp HAVING ( COUNT(emp) = 1 ) …

To install eVB 3.0 (embedded visual basic) on Windows 7: You first need: pocket PC 2002 SDK, eVB 3.0, vb runtimes 6.0 Control Panel > User Accounts > User Accounts > Change User Account Control settings Lower the ‘Notify’ bar …

The procedure is for the Lenovo Netbook but may also work with other brands in a similar way. Insert boot media and start installation When prompted, select Custom/advanced setup Install on partition where ‘Lenovo’ volume sits This will add the …

To extract a jar file from the command-line: jar xf myapp.jar -extract a jar-file into jar-file-name-dir (within same dir) jar xf myapp.jar file1 file2 file3 -extractspecific files only jar cf myapp.jar file1 file2 dir1 -create a jar-file from a path(s) …

To move a dir/file in linux: mv ./sourceDir ./destDir …this moves the current sourceDir to a destination dir …

To delete all contents of a dir including other dirs: rm -rf ./* rm = remove -r = recursive -f = force non-emty deletion ./* = everything in current dir …

In bash/shell: sqlplus /nolog #just log onto sqlplus console connect as sysdba #connect as sysdba and prompt for login connect user/passw as sysdba #log-in as a sysdba with user | default: system/manager In <bash><sql>: startup –startup a database shutdown –shutdown …

Some of the most useful vi commands: Insert (key) …edit mode Esc (key) …exit edit mode :wq or ZZ …save and exit vi (must not be in edit mode) :q! …exit vi without saving (must not be in edit mode) …

When you create a phpBB3 forum and use Oracle as the database host. make sure that you are using Oracle Database 10g or later as previous releases may cause unpredictable errors, i.e.: SELECT a.*, b.*, ac.something… FROM phpb3_forums a, phpb3_topics …

To check environment vars in a linux setup: set …this should return a list of the environment entries and can retrieve entries like: HOME # the active user’s home dir HOSTNAME # the server’s name ORACLE_HOME # the default path …

When checking if a listener is active or not in Oracle: lsnrctl status This command should return something similar to the following. Check-out the Services summary: Services Summary… Service “PLSExtProc” has 1 instance(s). Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) …

The logic is to have the various list-of-values (or combo-values) in a related global table. in global table: create the table that will hold the values -i.e. ‘city’ in related table: add an ‘unrelated’ relationship from global of the new …

To create a new HTTP Virtual Host in Oracle Application Server: Adding a new port number for the HTTP VH to listen to: login to the Oracle Enterprise Manager (i.e. domain.name.com: 1810) select the application server instance (under Standalone Instances) …

?To test/check from/in which database you are working from: select name from v$database …this will return the name of the database you are working on. …

Finding files/dirs in the bash shell: find /home -print | grep php #/home = the path to search in #-print = print output to screen #grep = what follows is the search pattern #php = the search term #| = …

You need to look for a service in linux: ps -ef | grep crystal e = look in all processes f = display full output details grep = print lines matching a pattern crystal = the search term to check …

When you delete items from a Portal they are not automatically purged. To save/purge your deletions: Navigator > page group > Pages > find the page > click Edit link from Editing Views: Graphical |  Layout |  List Select the pages to …

Creating a relationship using a global variable in FM10: create the relationship in the graph of FM (i.e. person: person_pk to history: person_fk) from inside a script, if you need to view the relationship: Set Variable If Go …

There are a few ways to edit a page in Portal: under ‘Build’ tab > Edit a Page > select page > click Edit Navigator > page group > select Pages > find the page > click Edit link under …

If you have created a ‘Page Group’ or an ‘Instant Portal’ you can quickly change an object type, do this: select the ‘Page Group’ and click edit click the ‘Configure’ tab to make changes/additions to object types You can also …

To install forum on Oracle Application Server: need access to OAS server (http server) log-in to OAS manager (em) and add a ‘virtual host’ under HTTP-Server -set path (Document Root:  i.e. ‘/phpbb3’ ) -set port (any available ports, i.e. ‘8888’ ) …

After log-into Oracle Portal as Administrator: click Administer tab under ‘SSO Server Administration’ section, click ‘Administer External Applications’ link click ‘Add External Application’ link and fill-in the relevant information to create it When this is done, the external application is …

After log-in to Oracle Portal: click on the link ‘Navigator’ in the list of ‘page groups’ find the name-group you created and click on ‘edit page root’ (this will allow you to edit the main page of the portal) clicking …

Build a fully-blown Portal (Instant Portal), ready to modify and use. …

To copy selected text within a command-line window from/to PuTTY… from PuTTY to windows: to copy the text from PuTTY, select it and right-click to paste into windows, use the normal Ctrl + V from windows to PuTTY: to copy …

The Apache configuration file is an entry point for how and what can be seen from the domain’s public url. config file is found: /home/username/Apache/Apache/conf/httpd.conf important settings: Port = the port the server will listen when not using SSL (defaults …

To check whether your linux-box has PHP installed or not: From the command-shell run: rpm -qa | grep -i php this should return something like this: php-cli-5.1.6-5.el5 php-5.1.6-5.el5 php-common-5.1.6-5.el5 php-ldap-5.1.6-5.el5 Or, you could run a test.php file within the htdocs …

after logged-in as some user (i.e. as root) $ type ‘su -dennis’ this should prompt you to enter the password of the user success if you see the prompt as: $ …

To copy selected text within a command-line window in xming: to copy the text, use Alt + Shift + C to paste into windows, use the normal Ctrl + V …

login to your linux-box enter the command i.e.:  cat /etc/redhat-release (outputs i.e. #Red Hat Enterprise Linux Server release 5) This will display the rehat version you are using. Similar is for other linux-boxes like i.e. using slackware-version instead would show …

download PuTTY and run it (all windowz) select Category > Session -on the left pane of PuTTY on the right-pane enter the server info: – Host name (or IP addres): the.server.ip (i.e. 192.168.10.205) – Port: the.port.number (i.e. 22) – Connection …

To make Oracle SQL Developer (2.x) load/work faster: From Menu: Tools > Preferences > Extensions, uncheck: “Automatically check for updates” From Menu: Tools > Preferences > Environment, uncheck: Show splash screen at startup Autonmatically load externally modified files Check for …