Get highest 3 salary in Oracle 10g

Hello and Welcome back.



This is my first blog since I returned  to Egypt  as I was working in KSA for year and half.



Here's how to get the highest three salaries in HR Schema using SQL.



# Old method was using ROWNUM , but it's not accurate  because it returns the first 3 rows only using the following code :

SELECT   *

  FROM   (  SELECT   last_name, salary

              FROM   employees

          ORDER BY   salary DESC)

 WHERE   ROWNUM <= 3

here's what you  get :

LAST_NAME SALARY
King 24,000
Kochhar 17,000
De Haan 17,000

But  using an other method using Dense_Rank() Over , returns results more accurate.
Here's the code:
SELECT   *
  FROM   (SELECT   last_name, salary,
                   DENSE_RANK () OVER (ORDER BY salary DESC) top_rank
            FROM   employees)
 WHERE   top_rank <= 3
here's what you get :
LAST_NAME SALARY TOP_RANK
King 24,000 1
Kochhar 17,000 2
De Haan 17,000 2
Russell 14,000 3
Thanks for  CodeProject Site

LogMeIn XP install bugs , how to fix !

The official LogmeIn installer for windows XP and server 2003  does not  work.

The old  installer worked perfect , you can download it from here..

But after installing LogMeIn on Windows Server 2003 , I got Your Computer Offline error .

Me and my friend Nouh  could fix it by the following steps :
# open Internet Explorer -
# goto Tools - Advanced 
# scroll to the end of it 
# enable TLS 1.0  
# disbale  SSL 3.0.
you're done !

Accessing your Virtualbox Guest from your Host OS

  1. If your guest machine is running, shut it down first.
  2. Click on File->Preferences in the VirtualBox menu-bar.
    screenshot-vbox-menubar
  3. Select the Network option from the side menu and click on the Host-only networks tab.
    screenshot-vbox-host-only-network-add-new
  4. The default options for the newly-created Host-only network should be fine. If not, you can add the following data manually, by clicking on the Edit button in the DHCP Server tab.
    • Server Address192.168.56.100
    • Server Mask255.255.255.0
    • Lower Address Bound192.168.56.101
    • Upper Address Bound192.168.56.254
    Don't forget to check the Enable Server option.
    screenshot-vbox-host-only-network-edit
    screenshot-vbox-host-only-network-dhcp-settings
  5. Now save all the settings in Preferences.
  6. Now open up the settings of your Guest machine and navigate to the Network option from the side menu and click on the Adapter 2 tab.
    screenshot-vbox-guest-settings
    screenshot-vbox-guest-settings-network-
  7. In the Attached to section, click on the dropdown and choose Host-only Adapter and in the Name section nested in it, choose the newly-created Host-only network.
    Don't forget to check the Enable Network Adapter option.
    screenshot-vbox-guest-network-adapter
  8. Save these settings and boot into your Guest machine.
  9. After logging in, type ifconfig. Note the new IP, it should be under a new interface like eth0 or vboxnet0. Now you can use this IP to SSH, view the webpages on your machine's Apache Server, etc..
Thanks to  2Ubuntu

How to create JDeveloper 12c Ubuntu desktop shortcut

How to launch Oracle JDeveloper 12c from desktop on Ubuntu.

1# Open Terminal (press CTRL+ALT+T)

2#Write the following code (replace by your Linux UsrName)
/home/USER/Oracle/Middleware/Oracle_Home/jdeveloper/jdev/bin/addjdevtodesktop

3# It's done.

Cannot use “Erase All Contents and Setting” in iOS 11 beta , Here's how to fix it

After Apple last iOS release 11 , I downloaded it using beta profile.

But I found that I cannot use “Erase All Contents and Setting”  under Settings.

Here's how to fix it.
1# Remove beta profile .
settings then General then Profile then iOS profile then Delete Profile then Restart iPhone

2# Sign Out  from iCloud

3# Restart iPhone  , and it's ok.

enjoy....

Apple IOS beta Profile to get latest iOS

Apple Beta software :

After installing beta profile to your iOS device , you'll get the latest beta iOS version.

CAUTION : Create A Backup Of Your Data Before Installing Beta Profile !

Here's how to install beta profile:

1# On your iOS  device , launch Safari browser , then go to : https://beta.apple.com/profile/





2# Enter your iCloud data  and Sign in .
You should receive  notification on your other ios devices , and you get a verification number too.











3#After login  download beta  Profile 

4# install it 

5# Restart your device 

6# Go to Setting  ---General - Software- Check for updates--Install updates



download ,install and reboot.

enjoy...

Changing the JDK Compliance Level

Changing the JDK Compliance Level

You can change the compiler compliance level by going to the Java Compiler page as shown in the steps below.
  1. In the Project Explorer view, right-click on the project and then select Properties.
  2. Select the Java Compiler page in the Properties window.
  3. In the JDK Compliance section, select the desired Compiler compliance level.
  4. Click Apply and then Ok.


  5.  
If your project is a facet-enabled project, you will also need to set the Java version in the Project Facets page by doing the following.
  1. In the Project Explorer view, right-click on the project and then select Properties.
  2. Select the Project Facets page in the Properties window. This page lists the facets in the project and their versions.
  3. Select the desired version number for the Java facet.
  4. Click Apply and then Ok.


  5.  

How to send SMS from ORACLE forms 10g

Here's how to send sms message from Oracle application.



Explain:



Say we are subscribed to msegat.com service with the following credentials:



User Name : OMAR

Password :  123

User Sender : ThreeM    ( you got it from your sms site)

Text we'll send : My_Test_Message

Phone we'll send message to : 966123456789



Here's how the code will run:

/*Start of SMS code*/

SET serveroutput ON
SET Define OFF
 
DECLARE
    HTTP_REQ      UTL_HTTP.REQ;
    HTTP_RESP     UTL_HTTP.RESP;
    URL_TEXT      VARCHAR2(32767);
    URL VARCHAR2(2000);
     
     SMS_MSG VARCHAR2(160) := 'Congratulations! Your database has been configured propoerly for sending SMS through a 3rd party SMS Gateway';
     
BEGIN
    DBMS_OUTPUT.ENABLE(1000000);
--Based on your service provider, the following link format may differ from
--What we have specified below!   
 
UTL_URL.Escape(SMS_MSG,TRUE);
--UTL_URL.Escape manages escape characters like SPACE between words in a message.
     
   
 
    HTTP_REQ  := UTL_HTTP.BEGIN_REQUEST(URL);
    
    UTL_HTTP.SET_HEADER(HTTP_REQ, 'User-Agent', 'Mozilla/4.0');
    HTTP_RESP := UTL_HTTP.GET_RESPONSE(HTTP_REQ);
 
    -- Process Request
    LOOP
        BEGIN
            URL_TEXT := null;
            UTL_HTTP.READ_LINE(HTTP_RESP, URL_TEXT, TRUE);
            DBMS_OUTPUT.PUT_LINE(URL_TEXT);
 
            EXCEPTION
                WHEN OTHERS THEN EXIT;
        END;
    END LOOP;
 
    UTL_HTTP.END_RESPONSE(HTTP_RESP);
END;
/*End of SMS code*/


If you got an error , you can remove :

SET serveroutput ON
SET Define OFF




"و فوق كل ذي علم عليم"