RelationalDBDesign
prev next prev next
  Course navigation
 
Lesson 12
Objective
Using Server Manager to execute SQL statements
Issue a SQL statement from Server Manager.
 
Learn how to issue a SQL statement from Server Manager.
In addition to executing the commands that you have already learned about in this module, you can use Server Manager to enter and execute any SQL statement.
The following example shows a SELECT statement used to retrieve a list of database users:
SVRMGR> SELECT username FROM dba_users;
USERNAME
------------------------------
SYS
SYSTEM
DEMO
DBSNMP
SCOTT
JGENNICK
7 rows selected.
SVRMGR>
Notice that the SQL statement has a semicolon at the end. SQL statements may span multiple lines, so the semicolon is used to tell Server Manager that it has reached the end of the statement. As an alternative to the semicolon, you can also use a forward-slash character to terminate a statement.
Here is how.
Using Server Manager - Quiz
Click the Quiz link below to take a quiz on using the server manager.
Using Server Manager - Quiz
  Course navigation