To insert data from excel sheet to oracle table

Luv u all ,


After long time im blogging ,,,:)
To insert data from excel sheet to oracle there are number of way to do it

1) Using SQL loader ( for huge records more than 1lkh , requires good knowledge about loaders)
2) Creating Insert Script ( simplest and easiest if you no MS Excel upto enough good extent , this will screw the performance if you forget  COMMIT ing Transaction after certain count of Insert statements)
3) And Third one is which most easiest i found (Dhan ta Dhyaaaannnnnnn ......)

Using Oraxcel
OraExcel is nothing but an VB Application which executes some MACROS in excel and connects to oracle database and does insert update operations okkkk....



1) download oracle excel extract it in folder
2) Open Excel Sheet  of which data needs to be inserted check 

3) create a table  in oracle with exact same column name as per ur excel sheet .also write that table name in any cell of ur excel.(this will be required in later stage ) 

4) open oraexcel it will promt you to enable Macros ,  click on Enable Macros

5)  Go to Excel Menu Bar -->Add Ins --> Oracle --> Connect
     Add database credentials (uname/password/sid) as per ur TNS file to connect database.
6) Go to  Excel Menu Bar -->Add Ins --> Oracle---> Insert --->  Multiple Rows
    Click on this and and Add the details of Cells in excel .such as Table Name , Column Names , Data
     Please Make the column names same as per ur Oracle Table Column Names. (This is Mendatory).
    Check Mark on Promt on Successfull Insert.
    Click OK and wait for 3-4 Minutes .
    U will receive successful insertion prompt 
7) Commit the transaction from  Menu Bar -->Add Ins --> Oracle--->Transaction---> COMMIT.
8) Check DB table , u ll find ur data.

Please Refer Below Images , for example.

 

~~~~~~~~~~~~~~~~~~~~~~~~~THE END ~~~~~~~~~~~~~~~~~~~~~~~~~~

Want Oraxcel ??? mark me a mail please vaibhav2khavare@gmail.com


Thanks ,

Vaibhav Khavare
"NO PAIN , NO GAIN "

Firefox stteing for running localhost

Here is the Solution for Other Users
Firefox - Enter username and password for "" at http://localhost - Solution
IIS uses Integrated Authentication and by default IE has the ability to use your windows user account...but don't worry, so does Firefox but you'll have to make a quick configuration change.

1) Open up Firefox and type in about:config as the url

2) In the Filter Type in ntlm

3) Double click "network.automatic-ntlm-auth.trusted-uris" and type in localhost and hit enter

4) Write Thank You To Blogger

Windows Vista RED edition

Microsoft is set to release the (PRODUCT) RED version of Windows Vista Ultimate on December 15th. Dell has been selling computers preloaded with this special version of the OS for a few months now, but starting next week you'll be able to to buy a standalone copy.

So what makes Windows Vista Ultimate (PRODUCT) RED different from plain old Windows Vista Ultimate Edition? First, it comes in a red box and includes a few extra wallpapers, screensavers, sidebar gadgets, and a Dreamscene moving background. Second, a portion of the proceeds from sales will help buy and distribute AIDS medications to patients in Africa.

Amazon appears to be selling it for about $70 more than the price of the vanilla edition of Windows Vista Ultimate, which means either that those wallpapers (which you can probably find online for free) are really awesome, or Microsoft or Amazon are jacking up the price a bit in order to support the charity.

[via iStartedSomething]

How 2 Extract Images from PDF files

PDF Image Extract is a free Windows utility that does exactly what the name suggests: it extracts images from PDF files. Sure, you could save pictures one at a time the old fashioned way by hitting print screen and pasting the image into an editor or using a screen capture program. But PDF Image Extract saves you a lot of time if you want to save multiple images because it will save every single image in a PDF file for you. In fact, you can create batch jobs to save images from multiple documents.

The only down side? I'm not kidding when I say PDF Image Extract saves every image. You'll likely wind up with a folder containing hundreds of images, only a few of which are the ones you were looking for. That's because the program will save all sorts of segments of the original PDF as image files, including the background.

FireFox3 Hitz the WEB....

On June 17, 2008 Mozilla attempted to set a Guinness World Record for the most downloads in a 24 hour period. According to Mozilla over 8 million downloads were recorded. Currently they are awaiting word from Guinness if they were successful.

But there was one thing we wanted to know about this number. Out of the 3 major operating systems in use today which one blazed away with the most downloads. So we decided to ask and a Mozilla spokesperson gave us the following numbers:

• Windows 79%
• Linux 13%
• OS X 8%

Now the number 1 spot didn't surprise us at all since Windows leads in overall computer operating systems it's almost a given that most of the downloads would come from Windows. But what was a bit surprising was that Linux bested OS X in the numbers of downloads.

One could say that Ubuntu, which is a very popular Linux distro comes packaged with Firefox so it's only natural that more downloads would come from Linux users. But according to w3counter, OS X accounts for 4.95% of the operating systems in use while Linux is barely half of this at 2.01%

So this strikes us as odd. What would cause OS X to slip to 3rd place in the number of downloads? Do these numbers suggested that Apple users only like to use Apple apps? Or did a large group of Mac users not get invited to the download party?

Google hack helps u to find what u want

Google is a pretty powerful search tool. You knew that. You can use it to find information, but you can also use it to find downloadable MP3s, books, videos, and other items. We're going to assume you're just looking for legally available downloads, but the truth of the matter is if someone's posted an MP3 (copyrighted or not) to their web page, Google can find it.

But who has the time to memorize all the search modifiers like "-inurl:(htm|html|php) intitle:"index of" +"last modified" +"parent directory" +description +size +(.mp3|.wma|.ogg) ?" That's where Google Hacks comes in. This handy little app will let you search for dozens of file types, song lyrics, cached pages, fonts, and other little goodies hanging out on the web.

Just download and install Google Hacks for Mac, Linux, or Windows, fire it up and enter your search term and check the boxes next to the type of search you want to perform. Your results will show up in your default web browser.

Yahoo!Messenger 9.0 beta out .Adds inline video support

Yahoo! has launched a public beta of Yahoo! Messenger 9. The update includes a bunch of boring but important updates like localized versions for more countries including Indonesia, Thailand, and the Philippines. But the big news is that you can embed videos, images, and maps in a chat window.

If you copy and paste a YouTube URL into a message, a video window will pop up. You can also add a Flickr slideshow or drag and drop images from your desktop.

The new IM client also has a redesigned contact list. When you hover over a friend, options pop up for sending an IM message, SMS text message, or starting a voice call. You can also customize the look with new skins, and you can add emoticons to your status message.

Yahoo! Messenger 9 beta is available for Windows XP and Vista. There are other versions available for Mac, Linux/Unix, mobile, or web chat.