This content has been marked as final. Show 5 replies
You are at the correct place, my friend. Create an OTN account & get the below...
*11g XE (Express Edition)* -- http://www.oracle.com/technetwork/products/express-edition/downloads/index.html
SQL Developer -- http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
This is the free IDE from Oracle.
Currently i'm using both of these for my personal practice.
Oracle Documentation "*The Bible of Oracle*" --
10g - http://www.oracle.com/pls/db102/homepage
11g - http://www.oracle.com/pls/db112/homepage
For all Oracle materials, i consider the master link to be - http://tahiti.oracle.com/
Please let me know if you have other concerns.
first create you a free Oracle Account on otn.oracle.com
Next download you a Express Edtion.
A good starting point can be the oracle learning library.
Or check out the blogs and newsletters on otn.oracle.com depends in what you want to learn. Also keep in mind that you can access the documentaion from otn.oracle.com or from http://tahiti.oracle.com/
hope this helps
915461 wrote:ranit and phaeus have given you some very good specific pointers. Please allow me to point out something a bit more general for your situation
1st of all thanks for clicking my post. I am new to Oracle so thouth to post where I got oppertunity.
Can anyone help with sample databast name or link for Oracle 11g express edition. I have MS SQL Server background 2005/2008 and I am very new to Oracle. I got oppertunity to work on Oracle between I want to practice like I practiced on AdventureWorks for SQL Server.
Also, if you have links of some really good tutorial for SQL and PL SQL oracle 10g or 11g then please help with same :)
When approaching Oracle you should forget everything you know from SQL Server. The products are fundamentally and profoundly different, from their internal architecture all the way out through their user interfaces. The similarities begin and and with SELECT * FROM EMP;. Even the term 'database' has a very different conceptual meaning. You've already been pointed to the doc set at tahiti.oracle.com. Please go there, then
Drill down to your product and version.
<b><i><u>BOOKMARK THAT LOCATION</u></i></b>
Spend a few minutes just getting familiar with what is available here. Take special note of the "books" and "search" tabs. Under the "books" tab you will find the complete documentation library.
Spend a few minutes just getting familiar with what <b><i><u>kind</u></i></b> of documentation is available there by simply browsing the titles under the "Books" tab.
Open the Reference Manual and spend a few minutes looking through the table of contents to get familiar with what <b><i><u>kind</u></i></b> of information is available there.
Do the same with the SQL Reference Manual.
Do the same with the Utilities manual.
You don't have to read the above in depth. They are <b><i><u>reference</b></i></u> manuals. Just get familiar with <b><i><u>what</b></i></u> is there to <b><i><u>be</b></i></u> referenced. Ninety percent of the questions asked on this forum can be answered in less than 5 minutes by simply searching one of the above manuals.
Then set yourself a plan to dig deeper.
- Read a chapter a day from the Concepts Manual.
- Take a look in your alert log. One of the first things listed at startup is the initialization parms with non-default values. Read up on each one of them (listed in your alert log) in the Reference Manual.
- Take a look at your listener.ora, tnsnames.ora, and sqlnet.ora files. Go to the Network Administrators manual and read up on everything you see in those files.
- When you have finished reading the Concepts Manual, do it again.
915461 wrote:If you install the Oracle Express database, there are sample databases that can be used for practice, such as the HR schema etc. These are all in the documentation you've been pointed to.
Hi Ranit B.
Thank you so much for your help. I am looking for any sample database on which I can practise as I use to do it Adventure Database in SQL Server.
Can you please help. :)