Scripts and iSQL*Plus

1
Scripts and iSQLPlus

• SQLPlus over the Internet

2
To connect to iSQLPlus
3
NOTE!!!

• The web page address is
• The computer name (ferdia2.student.comp.dit.ie)
• A colon ()
• The port number (5560)
• Followed by /isqlplus
• Logging on
• The Username is the schema name you have been
  given.
• The password is the password you have been given.
• The Connect Identifier is FT2284.
• This is different to the host string that you use
  for SQLPlus.
• So its http//ferdia2.student.comp.dit.ie5560/is
  qlplus

4
Sample session
5
History of session
6
Logging out
Click the logout hyperlink.
7
Scripts

• These are files containing a sequence of commands
  that you can otherwise enter interactively.
• The file is saved for convenience and
  re-execution.
• scripts are often called by operating-system
  specific names.
• In SQLPlus, you can execute the script with the
  START, _at_ or _at__at_ commands.

8
Points to note about iSQLPlus

• The screen formatting is done nicely in HTML.
• If you use substitution variables or Accept in
  your script, you are presented with a box to
  enter data.
• You must stick to the rules about surrounding
  strings with quotes.
• You must click continue return doesnt work.