December 2000
Intermediate to advanced
224 pages
9h 52m
English
Content preview from SQL in a Nutshell
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Name
DISCONNECT
Synopsis
The DISCONNECT
statement terminates a connection to the DBMS.
|
Vendor |
Command |
|---|---|
|
SQL Server |
Supported, with limitations |
|
MySQL |
Not supported |
|
Oracle |
Supported, with variations |
|
PostgreSQL |
Not supported |
SQL99 Syntax and Description
DISCONNECT {CURRENT | ALL | connection_name}This command ends one or more connections created between the current
SQL process and the database server. The CURRENT
clause closes the currently active user connection. The
ALL
clause closes all open
connections for the current user. Alternately, it’s possible to
close only a specific connection.
Microsoft SQL Server Syntax and Variations
Microsoft SQL Server supports DISCONNECT in
Embedded-SQL (ESQL) only, not within its ad hoc querying tool, SQL
Query Analyzer. It supports the full SQL99 syntax. When disconnecting
from Microsoft SQL Server in an ESQL program, the
DISCONNECT ALL command should be used to
disconnect cleanly from the database server.
Oracle Syntax and Variations
DISC[ONNECT]
In contrast to SQL Server, Oracle allows
DISCONNECT
only in its ad
hoc query tool, SQL*Plus. In this usage, the command ends the current
session with the database server but otherwise allows work in
SQL*Plus to continue. For example, a programmer can continue to edit
the buffer, save run files, and so on. However, a reconnection must
be established to issue any SQL commands. Exiting SQL*Plus and
returning to the filesystem requires the EXIT or
QUIT commands.
Oracle also supports this functionality with ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.