Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to use sqlplus to create DDL and DML operation methods", the content is easy to understand, clear, hope to help you solve your doubts, the following let Xiaobian lead you to study and learn "how to use sqlplus to create DDL and DML operation methods" this article.

1. Connect to the database

When window enters command-line mode, tap sqlplus will

Then perform the DDL operation of the table

For example:

DML operation: you can insert and update the data to the schema you just established.

Such as the insertion of data

* * it is important to note that:

* * if you make the following mistake first

Solution: put a semicolon at the end of each sentence

2 represents the second line.

The semicolon is the end in the sqlplus tool. If a semicolon is not written at the end of a sql statement, then sqlplus believes that the sql statement is not completed, and enter is a newline, then oracle automatically names the original line as the first line, and now edits as the second line, and if you enter a carriage return, there will be 3, and so on, until the semicolon appears.

Sqlplus is the most basic oracle database interaction tool, and other oracle interaction tools are developed on this basis. Sqlplus adheres to the strict sql specification, does not package any functions, and everything needs to be entered manually, so including semicolons that can be exempted from other tools, and so on, can also be fully entered in sqlplus.

All right, we got the results!

The above is all the contents of the article "how to create DDL and DML with sqlplus". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.