OraFAQ Forum: Training & Certification » Practising PL/SQL in Oracle 11g Enterprise 11.2

Home » Other » Training & Certification » Practising PL/SQL in Oracle 11g Enterprise 11.2 (Windows 7, 32 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #645335]

Thu, 03 December 2015 12:14

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

Report message to a moderator

Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #645336 is a reply to message #645335]

Thu, 03 December 2015 13:30

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #645342 is a reply to message #645335]

Thu, 03 December 2015 14:50

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.

Report message to a moderator

Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #656434 is a reply to message #645335]

Wed, 05 October 2016 14:32

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)

Report message to a moderator

Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #656435 is a reply to message #656434]

Wed, 05 October 2016 14:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://www.oracle.com/downloads/index.html

is GOOGLE broken for you?

Report message to a moderator

Re: Practising PL/SQL in Oracle 11g Enterprise 11.2 [message #656463 is a reply to message #656435]

Thu, 06 October 2016 12:37

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".

Report message to a moderator

Previous Topic:	OCM 11g or 12c suggestion / queries
Next Topic:	Test Strategy Still Valid? -- Matt Morris Article

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 02 06:03:37 CST 2025