Home » SQL & PL/SQL » Client Tools » OraCmd,help
icon4.gif  OraCmd,help [message #355636] Sun, 26 October 2008 13:05 Go to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
i hav oracmd (2.0.1.41) and RazorSQL(4.2.9) installed on my system(window xp.sp2)
i just want to practice oracle commnds,but oracle download is too big
but these soft wares ask me to connect first
is there any free oracle database that i can connect to?
or any other way to practice without any connection?
please help quickly,i hav to preapre for test. Confused
Re: OraCmd,help [message #355637 is a reply to message #355636] Sun, 26 October 2008 13:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can download Oracle 10g XE (database) and SQL Developer (query tool) on otn.oracle.com

You can also create a workspace on apex.oracle.com and work with it.

Regards
Michel

[Updated on: Sun, 26 October 2008 13:39]

Report message to a moderator

Re: OraCmd,help [message #355640 is a reply to message #355637] Sun, 26 October 2008 14:20 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
thank u so much, i will try them right now
Re: OraCmd,help [message #355687 is a reply to message #355640] Mon, 27 October 2008 01:39 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
could any one please explain how to use these...
i m very new to oracle(3 days only)
please its urgent Confused
Re: OraCmd,help [message #355689 is a reply to message #355687] Mon, 27 October 2008 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I advice you to read OraFAQ Forum Guide, "Useful Sites" section.

Regards
Michel
Re: OraCmd,help [message #355692 is a reply to message #355689] Mon, 27 October 2008 01:57 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
thanx for your help Michel
just tell me 1 thing
do i hav to make a link between Oracle Client 10g Express Edition and Query Tool (using ODBC) 6.1 (which u asked me 2 dwnld),or they hav to be used separately ?
please give a little explanation .
please tell if i can practice on these softwares in offline mode & how??
Re: OraCmd,help [message #355703 is a reply to message #355692] Mon, 27 October 2008 02:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
One of the very important parts of learning Oracle (or any programming tool/language for that matter) is to learn to search.
Almost any question you can come up with has been asked and answered before on the web.
Re: OraCmd,help [message #355732 is a reply to message #355703] Mon, 27 October 2008 04:42 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
Frank wrote on Mon, 27 October 2008 02:49
One of the very important parts of learning Oracle (or any programming tool/language for that matter) is to learn to search.
Almost any question you can come up with has been asked and answered before on the web.



i hav spent many hours on net ,before posting in this forum
the fact is i m very new to sql,therefore doesnt know terms associated with it,thats y search results are not good
first i installed mysql,later found out it had diff syntax than oracle commnds
thn intalled oracmd,but it reqires connection to server
thn installed razorsql.but it also requires connection

i know oracle has an option of creating database on hardisk itself,i m looking for an option like this

in oracle 10g xe's manual it requires log in on homepage,but where is home page?
in query tool ,i choose "query disconnected" ,but whn i try to execute ,it asks for a data source,how to create that?

i just want to get started ,plz write a lilttle explanation of how to practise oracle commnds in offline mode
i will be really thankful
Re: OraCmd,help [message #355734 is a reply to message #355732] Mon, 27 October 2008 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
practise oracle commnds in offline mode

Explain what does this mean.

Regards
Michel
Re: OraCmd,help [message #355735 is a reply to message #355734] Mon, 27 October 2008 04:51 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
it means i want to practise sql commnds with respect to oracle syntax,without connecting to any online server
(like in oracle ,one can practise ,by making database on their harddisk,no net connection required )
Re: OraCmd,help [message #355739 is a reply to message #355735] Mon, 27 October 2008 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the only way is to have a local database and and the easiest way is to download XE as I said in my first post.

Regards
Michel
Re: OraCmd,help [message #355740 is a reply to message #355739] Mon, 27 October 2008 05:22 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
Michel Cadot wrote on Mon, 27 October 2008 05:15
So the only way is to have a local database and and the easiest way is to download XE as I said in my first post.

Regards
Michel




please provide a little explanation or any link to do so
Re: OraCmd,help [message #355746 is a reply to message #355740] Mon, 27 October 2008 06:00 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is the Oracle Technology Network site. There's the Download section there, so - take a look what's offered.

Besides, there are "Featured Downloads" on the right upper corner of the homepage; you'll find "Oracle Database XE" there.
icon14.gif  Re: OraCmd,help [message #355748 is a reply to message #355746] Mon, 27 October 2008 06:04 Go to previous message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
thank u guys so much for your help Smile

[Updated on: Mon, 27 October 2008 06:05]

Report message to a moderator

Previous Topic: Toad window lost, how to recover
Next Topic: ENTER DOESNT WORK HELP!!!
Goto Forum:
  


Current Time: Tue Dec 06 08:51:56 CST 2016

Total time taken to generate the page: 0.11736 seconds