O'Reilly logo

SQL: Visual QuickStart Guide by Chris Fehily

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Running SQL Programs

In this chapter, I’ll describe how to run SQL programs in these DBMSes:

  • Microsoft Access 2002

  • Microsoft SQL Server 2000

  • Oracle 9i

  • MySQL 4.0

  • PostgreSQL 7.1

Microsoft Access’s graphical interface lets you run only one SQL statement at a time; to run multiple SQL statements, embed them in a Visual Basic program (not covered in this book). The other DBMSes let you run SQL programs in interactive mode or script mode. In interactive mode, you type individual SQL statements at a command prompt and view the results of each statement separately, so input and output are interleaved. In script mode (also called batch mode), you save your entire SQL program in a text file (called a script or a batch file), and a command-line utility takes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required