copy all files and folders using CMD

Copying files from one folder to another , may be hard for permissions or when using security software.



I found the following method to  copy   all files and subfolders too from one place to an other ,  using  command prompt.



XCOPY D:\Source_Folder    F:\Destination_Folder /h/i/c/k/e/r/y



I recommend using this method as it's really very fast  and ram non-consuming 



Source : StackOverFlow

ORACLE ly

My blogspot name  was generated automatically using Shopify .

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 !

Thanks to LogMeIn Client says "Your computer is offline. "

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.
   


3. Select the Network option from the side menu and click on the Host-only networks tab.
   


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 Address: 192.168.56.100
   
   
   • Server Mask: 255.255.255.0
   
   
   • Lower Address Bound: 192.168.56.101
   
   
   • Upper Address Bound: 192.168.56.254
   
   

   Don't forget to check the Enable Server option.

   
   


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.
   
   


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.

   


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....