Home » Other » Training & Certification » your recommends
your recommends [message #438406] Fri, 08 January 2010 13:57 Go to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
Dear All
I know most of SQL commands but I haven't software and my pc windows XP SP2 in order to I execute these commands in oracle database so I need your recommends , how can I begins

Thanks all
Re: your recommends [message #438407 is a reply to message #438406] Fri, 08 January 2010 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Download Oracle XE at
http://www.oracle.com/technology/software/products/database/xe/index.html

Regards
Michel
Re: your recommends [message #438409 is a reply to message #438406] Fri, 08 January 2010 14:04 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
dear Michel Cadot
is this software support windows XP SP2 .?
Thanks for reply.
Re: your recommends [message #438410 is a reply to message #438409] Fri, 08 January 2010 14:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it must be a Professional Edition not a Home one.

Regards
Michel
Re: your recommends [message #438435 is a reply to message #438409] Sat, 09 January 2010 00:24 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Do you know installation procedure with all parameters you have to specify?

regards,
Delna
Re: your recommends [message #438437 is a reply to message #438406] Sat, 09 January 2010 01:41 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
dear delna
I wish give me the procedures because till now the download wasn't completed
Thanks
Re: your recommends [message #438440 is a reply to message #438437] Sat, 09 January 2010 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
XE is easy to install.
Just follow the installer assistant and click on Next button.

Regards
Michel
Re: your recommends [message #438447 is a reply to message #438435] Sat, 09 January 2010 03:10 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
delna.sexy wrote on Sat, 09 January 2010 07:24
Do you know installation procedure with all parameters you have to specify?

regards,
Delna

This is why you always should recommend XE for beginners. You don't need to configure parameters, just your standard Windows installer.
Re: your recommends [message #438450 is a reply to message #438440] Sat, 09 January 2010 03:39 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
dear Michel
when I press to download link this message "We're sorry, the page you requested was not found." appear to me .

so are u have another link
thanks alot
Re: your recommends [message #438455 is a reply to message #438450] Sat, 09 January 2010 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When I click on the link I gave you then on "Oracle Database 10g Express Edition for Microsoft Windows" link I get the following page, do you get it?

/forum/fa/7287/0/

Regards
Michel
  • Attachment: OracleXE.JPG
    (Size: 164.59KB, Downloaded 2156 times)
Re: your recommends [message #438460 is a reply to message #438406] Sat, 09 January 2010 05:07 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
dear Michel
yea I get and I press to accept License agreement but when I press to "OracleXE.exe"or "OracleXEUniv" the message appear to me

Thanks for you cooperation
Re: your recommends [message #438463 is a reply to message #438460] Sat, 09 January 2010 05:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In order to be able to download Oracle products from the Oracle Technology Network, you need to create a (free) account. Did you do that?
Re: your recommends [message #438464 is a reply to message #438406] Sat, 09 January 2010 05:23 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
yes my friend
I created free account .

ok my friends I will try to download it

Thanks all
Re: your recommends [message #438465 is a reply to message #438464] Sat, 09 January 2010 05:30 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh well, it seems that you'll have to wait a little bit; I've just tried to start the download, and got

Registration Error.

We're sorry. The authentication server is temporarily unavailable.


Try again later.
Re: your recommends [message #438517 is a reply to message #438406] Sun, 10 January 2010 02:18 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
colleagues
now I install oracle 8 but I don't know the username and password for Oracle SQL 8.1.7.0

Thanks
Re: your recommends [message #438518 is a reply to message #438517] Sun, 10 January 2010 02:49 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle 8?!? Not exactly the newest version, but OK, better anything than nothing, I guess.

I suppose that you should really read the documentation - installation guide, getting started and similar. In there you'll find answers to most of your questions.

Default passwords are (were):
username   password
--------   -----------------
sys        change_on_install
system     manager
scott      tiger (this is a sample schema)

Don't do ANYTHING in SYS or SYSTEM schema; test your skills in newly created one or use SCOTT's schema.
Re: your recommends [message #438523 is a reply to message #438406] Sun, 10 January 2010 05:11 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
Dear All
now every thing is okay , I thanks all , but how can I know how many tables I have in my database .

Thanks again
Re: your recommends [message #438531 is a reply to message #438523] Sun, 10 January 2010 10:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You count them, obviously.

I suppose that you mean "your schema", not in "your database". So, if we guess that you are already connected to SQL*Plus, you'd
SQL> select count(*) from tab;

  COUNT(*)
----------
        11

SQL>

But seriously, you should read the documentation. Asking for each and every command you are interested in might take a long time, if we'll do that interactively.
Re: your recommends [message #438535 is a reply to message #438406] Sun, 10 January 2010 12:53 Go to previous messageGo to next message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
Dear
Thanks I execute below commands was ok ,
--------------------------------------------------------------
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 10 21:49:34 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect hr/hr
Connected.
SQL> select count(*) from tab;

COUNT(*)
----------
8
----------------------------------------------------------------
this mean I have 7 tables in hr user ,but can I know how many users
thanks
Re: your recommends [message #438537 is a reply to message #438535] Sun, 10 January 2010 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query ALL_USERS but as Littlefoot said first read the documentation otherwise you will have a question every minute during a year.

Start with Database Concepts to know how Oracle works
then Database Reference which contains all useful system views
then Administrator's Guide as you administer your ownn database
then Database SQL Reference without it you won't be able to do anything
then PL/SQL User's Guide and Reference and Application Developer's Guide - Fundamentals if your profile is developer one.

Regards
Michel

[Updated on: Sun, 10 January 2010 15:09]

Report message to a moderator

Re: your recommends [message #438542 is a reply to message #438406] Sun, 10 January 2010 15:00 Go to previous message
yaser_nss
Messages: 10
Registered: January 2010
Location: Iraq
Junior Member
dear Michel
Kindly from this time I try to read all link you give me in order to I know more to oracle ,and I thanks all my friends which help me .

best regards
Previous Topic: Complete SQL, PLSQL
Next Topic: Examkiller IBM 000-004 examination promotion
Goto Forum:
  


Current Time: Fri Mar 29 01:12:40 CDT 2024