Les 02

2

Working with iSQL*Plus

Copyright © 2004, Oracle. All rights reserved.

Objectives After completing this lesson, you should be able to do the following: • Differentiate between SQL statements and iSQL* Plus commands • Log in to iSQL* Plus • Identify the various user interface elements of the iSQL*Plus window • Load, save, and execute script files • Configure the iSQL*Plus settings

2-2

Copyright © 2004, Oracle. All rights reserved.

Differentiating Between SQL Statements and iSQL*Plus Commands

SQL statements

Internet browser

Query results

iSQL*Plus commands

Client 2-3

Oracle server

Formatted report Copyright © 2004, Oracle. All rights reserved.

Differentiating Between SQL Statements and iSQL*Plus Commands SQL • A language • ANSI standard • Does allow abbreviated

keywords • Statements manipulate data and table definitions in the database.

SQL statements

2-4

SQL buffer

iSQL*Plus • An environment • An Oracle proprietary tool • Allows abbreviated

keywords • Commands do not allow manipulation of values in the database. • Runs on a browser • Is centrally loaded; does not have to be implemented on each machine

iSQL*Plus commands

Copyright © 2004, Oracle. All rights reserved.

iSQL*Plus buffer

Introducing iSQL*Plus After you log in to iSQL*Plus, you can: • Describe table structures • Enter, execute, and edit SQL statements • Save or append SQL statements to files • Execute or edit statements that are stored in saved script files • Load commands from a script file into the iSQL*Plus window • Create, reference, and display SQL*Plus variables

2-5

Copyright © 2004, Oracle. All rights reserved.

Logging In to iSQL*Plus From your Windows browser environment:

2-6

Copyright © 2004, Oracle. All rights reserved.

Understanding the iSQL*Plus Environment 7 8 1

9 2

3

4

5

6

2-7

Copyright © 2004, Oracle. All rights reserved.

10

Interacting with Script Files

SELECT last_name, hire_date, salary FROM employees;

1

2

2-8

Copyright © 2004, Oracle. All rights reserved.

Interacting with Script Files 2

SELECT last_name, hire_date, salary FROM employees;

3

2-9

Copyright © 2004, Oracle. All rights reserved.

Configuring Settings Preferences icon

2-10

Copyright © 2004, Oracle. All rights reserved.

Configuring Settings

1 2

3

4

2-11

Copyright © 2004, Oracle. All rights reserved.

Other Development Tools

2-12

Copyright © 2004, Oracle. All rights reserved.

Summary In this lesson, you should have learned how to: • Differentiate between SQL statements and iSQL*Plus commands • Log in to iSQL*Plus • Identify the various user interface elements of the iSQL*Plus window • Load, save, and execute script files • Configure the iSQL*Plus settings

2-13

Copyright © 2004, Oracle. All rights reserved.

Practice 2: Overview This practice covers the following topics: • Differentiating between SQL statements and iSQL*Plus commands • Logging in to iSQL*Plus • Identifying the various user interface elements of the iSQL*Plus window • Loading, saving, and executing script files • Configuring the iSQL*Plus settings

2-14

Copyright © 2004, Oracle. All rights reserved.

2-15

Copyright © 2004, Oracle. All rights reserved.

2-16

Copyright © 2004, Oracle. All rights reserved.