如何用sql語句關閉資料庫

❶ mdb資料庫如何使用sql語句

1、打開mdb的一個數據；
2、打開主界面，點擊表student，可以查看它的內容；
3、點擊上方的創建；
4、繼續點擊查詢設計；
5、馬上會彈出一個窗口顯示表，直接點擊關閉；
6、右鍵圖中查詢1；
7、在彈出的列表中選擇SQL視圖；
8、看到SELECT，同時在這個方框內輸入圖中所示SQL語句；
9、點擊左上方的運行按鈕；
10、運行sql結果成功。

❷ 急急急 如何在SQL*Plus中，用命令行關閉和開啟Oracle資料庫伺服器

1. Set up your Oracle environment.

If you are using Windows operating system, do the followings:

set ORACLE_HOME=C:\oracle\proct\10.2.0.1.0
set ORACLE_SID=xxxxxxx

(Change C:\oracle\proct\10.2.0.1.0 to your own Oracle Home)
(Change xxxxxxx to your database name)

If you are using UNIX (e.g. HP-UX) operating system, do the followings:

export ORACLE_SID=xxxxxxx
export ORACLE_HOME=/u01/app/oracle/proct/10.2.0.1.0

(Change /u01/app/oracle/proct/10.2.0.1.0 to your own Oracle Home)
(Change xxxxxxx to your database name)

2. connect as sysdba

Start SQL*Plus, and connect to the database as sysdba. Use the following command:

connect sys/aaaaaaa@bbbbbbb as sysdba

(aaaaaaa is your password for sys)
(bbbbbbb is the connection string defined in tnsnames.ora)

3. Shut down or start up database.

To shut down, use this command:

shutdowm immediate

If the database has problem, and it hangs, use this command:

shutdown abort

To startup, use this command:

startup

If the database does not use spfile, and the pfile is not in the default location, use this command:

startup pfile=C:\aaa\bbb\ccc\ddd\init.ora

(C:\aaa\bbb\ccc\ddd\init.ora should be the init.ora file』s path of your database)

Good luck!

❸ 怎樣用sql語句刪除整個表及資料庫

工具/材料：Management Studio。

1、首先在桌面上，點擊「Management Studio」圖標。