What Does Windows x64 and x86 Mean?

Sometimes people will easily get confuse. Common sense perspective will easily says x86 is higher than x64. And some will miss interpret saying that x64 refer to 32bit and x86 is referring to 64bit operating system.

x64 is 64bit platform while x86 is 32bit platform for Operating System.

As the x86 term became common after the introduction of the 80386, it usually implies a binary compatibility with the 32-bit instruction set of the 80386. This may sometimes be emphasized as x86-32 to distinguish it either from the original 16-bit x86-16 or from the newer 64-bit x86-64 (also called x64). Although most x86-processors used in new personal computers and servers have 64-bit capabilities, to avoid compatibility problems with older computers or systems, the term x86-64 is often used to denote 64-bit software, with the term x86 implying only 32-bit.

How to check your PC Operating System running on what bit using Windows command prompt?

systeminfo <–type this and press Enter in command prompt

System Manufacturer:       LENOVO
System Model:              4236NUA
System Type:               x64-based PC
Processor(s):              1 Processor(s) Installed.
                           [01]: Intel64 Family 6 Model 42 Stepping 7 GenuineIntel ~775 Mhz
BIOS Version:              LENOVO 83ET61WW (1.31 ), 7/7/2011
Windows Directory:         C:Windows
System Directory:          C:Windowssystem32
Boot Device:               DeviceHarddiskVolume2
System Locale:             en-us;English (United States)
Input Locale:              en-us;English (United States)

Problem with string which contains an “&” in sqlplus

Today I got a task to automate data extraction for reporting purpose from Oracle SQL Plus. My method for this automation is like below:

1. Create a batch file to call SQL Plus program.
2. The SQL PPlus program will generate a HTML report for my boss to view it.

As simple as that. And my tools required are:

1. A simple *.bat file (which to create a automatic daily folder to restore the report)
2. SQL Plus program
3. A sql script will able to produce a HTML report (this is quite tough one). I can post on how to do this maybe later.

So, my problem is, in my script there is a compulsory string [&]. Which you may already know, the string [&] is being used by ORACLE to identify variable.

This is the solution:

SET DEFINE OFF

This command line needed to be put inside the sql file before reaching [&] string, and it will stop sqlplus interpreting [&].

Thats all for today.

Interesting Google Chrome Web Tools to capture a whole web page

For most of internet user, getting a snapshot of a web, or a picture from the web, is very common and sometimes it is difficult to mange.

But with Google Screen Capture for Google Chrome,to save a screenshot of a page is very interesting yet very easy to use. The best part of it, which I personally think very important and most interesting, this tool manage to capture the whole webpage from top to bottom of page. I love it so much!

Below are the simple step to install.

1. You will need a Google Chrome installed. If you do not have it, grab it here.
2. Open your chrome and click on the [Web Store] button located at right bottom of the Chrome page.
3. Search for [Google]
4. Scroll down and look for Google Screen Capture, and install it.

This is great tool, very much love it. Enjoy.