Subscribe to Windows IT Pro

 

Get Newsletters

  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Productivity Tips

Subscribe Now!

April 27, 2004 12:00 AM

Manipulate Oracle with SQL*Plus

Windows IT Pro
InstantDoc ID #42281
Rating: (0)

SQL*Plus is a utility that lets you query, modify, and manipulate Oracle database objects as well as carry out database maintenance activities. SQL*Plus is installed by default when you install the Oracle server. A command-line version of the tool offers functionality similar to SQL Server's Osql utility, and you invoke this version of SQL*Plus by typing

sqlplus

at a command prompt. The Windows GUI version of the tool is in the Oracle Application Development program group. For example, if your Oracle Home (i.e., the location you specify when you use the Oracle Universal Installer to install Oracle) is OraHome92, from the Start menu you'd navigate to All Programs, Oracle - OraHome92, Application Development, SQL Plus to access your Oracle Home. To install SQL*Plus on a client, you can use the Oracle 9i Release 2 client media, which you can download from the Oracle Technology Network Web site at http://technet.oracle.com/software/products/oracle9i/index.html.

Related Content:

ARTICLE TOOLS

Comments
  • Anonymous User
    8 years ago
    Dec 03, 2004

    I need the Username and Password to work in Orcle 9i Sql Plus.

You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

White Papers

Get your Windows 7 deployment off to the right start by implementing PC lockdown. A locked-down environment is easier and cheaper to support since users are less likely to make unnecessary changes to the core system configuration - read more here!

Essential Guides

Is your iSCSI "lossy"? The reality is that most off-the-shelf Ethernet hardware deployed for iSCSI can lose packets, resulting in slow performance or application downtime. Learn how to assess your current iSCSI infrastructure and engineer an advanced iSCSI SAN infrastructure.

Web Seminars

What's the best way to keep your network safe from malware? In this web seminar, security expert Greg Shields suggests an alternative method to the traditional blacklisting approach that is common with anti-virus and anti-malware solutions.

eLearning Series

We bring the experts direct to you to share their real-world perspective and expertise. During each event, three sessions stream in real time, so you can learn, ask questions, and get solutions.
Upcoming event: Getting the Most with Exchange 2010 with Paul Robichaux

Subscribe to Windows IT Pro!

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.