oraclesql

Data Definition

创新互联成立于2013年,是专业互联网技术服务公司,拥有项目网站制作、成都网站制作网站策划,项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命,1280元陆良做网站,已为上家服务,为陆良各地企业和个人服务,联系电话:028-86922220

          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.


分享名称:oraclesql
文章分享:http://myzitong.com/article/jicjoo.html