Home » Other » Training & Certification » Practising PL/SQL in Oracle 11g Enterprise 11.2 (Windows 7, 32 bit)
Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #645335] Thu, 03 December 2015 12:14 Go to next message
mmlogan
Messages: 3
Registered: December 2015
Junior Member
Hi All,
I am totally new in this forum as well as beginner level of Oracle. I installed Oracle Database 11g Release 2 (11.2.0.1.0) Enterprise Edition. Now I don't know which one in the start menu I need to use to start Oracle so that I can practice PL/SQL.

Thanks,

Mike
Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #645336 is a reply to message #645335] Thu, 03 December 2015 13:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64718
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Open a DOS box, set ORACLE_HOME and ORACLE_SID variable, include %ORACLE_HOME\bin in %PATH and execute "sqlplus /nolog".
Then you can start to connect and practice.
See the following manuals:
SQL*PlusĀ® User's Guide and Reference
Database SQL Reference
Database 2 Day Developer's Guide
Database Advanced Application Developer's Guide
Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #645342 is a reply to message #645335] Thu, 03 December 2015 14:50 Go to previous messageGo to next message
matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL
Senior Member

The links Michel has provided should help get you to the point where and Oracle instance is running. As far as learning to code in PL/SQL and working with it, I'd highly recommend downloading and installing SQL*Developer. I've done old-school SQL*Plus command-line PL/SQL development... and likely will again (if forced to at gunpoint). However, I certainly prefer the convenience of a development environment that makes it easier to see and change my code at need.
Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #656434 is a reply to message #645335] Wed, 05 October 2016 14:32 Go to previous messageGo to next message
Irish88
Messages: 36
Registered: August 2016
Location: Plains of Kansas
Member
I too, am looking to load up Oracle 11g and PL/SQL on my laptop at home to practice. Hopefully there is a practice database to download.
(Dell/ Windows 10 OS, 8GB RAM, 1TB HDD)
Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #656435 is a reply to message #656434] Wed, 05 October 2016 14:47 Go to previous messageGo to next message
BlackSwan
Messages: 25349
Registered: January 2009
Location: SoCal
Senior Member
https://www.oracle.com/downloads/index.html

is GOOGLE broken for you?
Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #656463 is a reply to message #656435] Thu, 06 October 2016 12:37 Go to previous message
Irish88
Messages: 36
Registered: August 2016
Location: Plains of Kansas
Member
>>is GOOGLE broken for you?<<

No it is not.

I omitted this statement from my post which was an error on my part:
"I'll dig around and see what I can locate".
Previous Topic: OCM 11g or 12c suggestion / queries
Next Topic: SQL Tuning course - free!
Goto Forum:
  


Current Time: Mon Apr 24 16:43:16 CDT 2017

Total time taken to generate the page: 0.05628 seconds