Data Definition CREATE, to create a new database
Data Definition
CREATE, to create a new database object
ALTER, to change an aspect of the structure of an existing database object
DROP, to drop (remove) a database object
Data Manipulation and Transactions
INSERT, to add rows to a table
UPDATE, to change column values of existing rows
DELETE, to remove rows from a table
COMMIT, to confirm all pending changes of the current transaction
ROLLBACK, to cancel all pending changes and restore the original situation
DELETE empties a table; DROP removes a table. TRUNCATE allows you to delete all the rows in a table in an efficient (but irrevocable) way.
UPDATE changes the contents of a table; ALTER changes its structure.
You can undo the consequences of data manipulation with ROLLBACK; data definition commands are irrevocable.
--结束END--
本文标题: oracle sql
本文链接: https://www.lsjlt.com/news/44762.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0