Home » SQL & PL/SQL » Client Tools » How to work with SQL from home PC
icon4.gif  How to work with SQL from home PC [message #543633] Thu, 16 February 2012 01:16 Go to next message
monoseej
Messages: 5
Registered: February 2012
Junior Member

HI All,

I am a very new to oracle.I want to practice Oracle SQL from home.What software i need to install. Even if i install SQL developer,SQL+ which database i can access n how.

Please guide me i will look for your reply


Thanks
Monoseej
Re: How to work with SQL from home PC [message #543634 is a reply to message #543633] Thu, 16 February 2012 01:27 Go to previous messageGo to next message
Littlefoot
Messages: 18821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Download and install Oracle 11g XE database. It is an excellent choice for a beginner. (You can connect SQL Developer to it).
Re: How to work with SQL from home PC [message #543637 is a reply to message #543634] Thu, 16 February 2012 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 57600
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
(... and SQL*Plus) Smile

Regards
Michel
Re: How to work with SQL from home PC [message #543640 is a reply to message #543637] Thu, 16 February 2012 01:36 Go to previous messageGo to next message
monoseej
Messages: 5
Registered: February 2012
Junior Member

Thanks my friend for replying to my post.

So first i have to download oracle 11g XE and then i have to download SQL developer.
Next i have to connect SQL developer to that database.

But and .ora files will i need to create? any particular username password for the database to connect.

Please can you tell me in details.. I am very new to this format.

Thanks again mate for replying to my post

Thanks
Monoseej
Re: How to work with SQL from home PC [message #543642 is a reply to message #543640] Thu, 16 February 2012 01:45 Go to previous messageGo to next message
Littlefoot
Messages: 18821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When you install that database, you'll have some sample schemas installed (such as HR - human resources). You can connect to it and practice SQL skills.

Or, you can create your own user and work with it (create tables, insert data, etc.). That's a little bit more complex (as you need to issue certain statements you might not be familiar with ... yet). Anyway, everything's written in documentation. Read it, just as they are written on the page (readme first, then Installation Guide, Getting started, 2 day DBA, ...).

Here's a complete 11g R2 documentation; you'll be interested in SQL reference book, I suppose. Feel free to search and read everything you are interested in. Also, bookmark this forum, come and ask.
Re: How to work with SQL from home PC [message #543692 is a reply to message #543642] Thu, 16 February 2012 08:22 Go to previous messageGo to next message
monoseej
Messages: 5
Registered: February 2012
Junior Member

Hi, Thanks for all the help... There is one query just to make sure I am downloading correct thing. I have gone to the given link for oracle 11g XE version and found two downloadable one for windows X32 and other is for Linux x64. will id download the database for the link (Oracle Database Express Edition 11g Release 2 for Windows x32). Please advise
Re: How to work with SQL from home PC [message #543696 is a reply to message #543692] Thu, 16 February 2012 08:35 Go to previous messageGo to next message
Michel Cadot
Messages: 57600
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Download the one that matches your OS.

Regards
Michel
Re: How to work with SQL from home PC [message #543702 is a reply to message #543696] Thu, 16 February 2012 08:49 Go to previous messageGo to next message
monoseej
Messages: 5
Registered: February 2012
Junior Member

I have Windowns XP as OS in my PC. then i think windows X32 will be suitable...Am i right?
Re: How to work with SQL from home PC [message #543704 is a reply to message #543702] Thu, 16 February 2012 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 57600
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: How to work with SQL from home PC [message #543706 is a reply to message #543704] Thu, 16 February 2012 08:53 Go to previous messageGo to next message
monoseej
Messages: 5
Registered: February 2012
Junior Member

Thanks very much... I will try and will reach if face any difficulty...Thanks again for helping me out n guiding me
Re: How to work with SQL from home PC [message #543878 is a reply to message #543706] Fri, 17 February 2012 05:56 Go to previous message
sarma.shp
Messages: 111
Registered: February 2012
Senior Member
SQL DEVELOPER IS the free tool ,it is an application based...but for a beginner like you ..just try to practice from sql*plus with all the queries(syntax) rather than going for apllication based ....That will be helpfull to you.
Previous Topic: Facing issue in wls1034_oepe111161_win32
Next Topic: Connecting directly to required database(not test database)
Goto Forum:
  


Current Time: Wed Apr 16 08:31:01 CDT 2014

Total time taken to generate the page: 0.10681 seconds