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

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

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.



 

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.



 

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License, and code samples are licensed under the Apache 2.0 License. For details, see our Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Source  : Google Dev.

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!   

 

URL := 'http://msegat.com/gw/?userName=OMAR&userPassword=123&numbers=966123456789&userSender=ThreeM&msg=My_Test_Message&By=Link&msgEncoding=UTF8'||

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

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