Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement.
The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed,
SQL * Plus command (1) Introduction: Oracle SQL * Plus is a client tool for interacting with Oracle. In SQL * Plus, you can run the SQL * Plus command and the SQL * Plus statement.
The DML, DDL, and DCL statements we usually call are SQL * Plus
1. Execute an SQL script file
SQL> Start file_name
SQL> @ file_name
We can save multiple SQL statements in a text file, so that when we want to execute all the SQL statements in this file, we can use any of the following commands, which is similar
SQL * PLUS maintains system variables, also known as SET variables. It can be used to create a special environment for SQL * PLUS interaction, such as: SETSet the display width of the NUMBER data, the NUMBER of rows per page, and the column width.
Why does echo fail when an SQL statement is inserted?
function execute_data($sql){$result = @mysql_query($sql) or die(mysql_error());@mysql_free_result($result) or die(mysql_error());return $result;}
$sql = "insert into test(name)
1.termorder:When used in conjunction with the spool command, the Sqlplus output can be canceled, and the query results exist only in the spool fileSet term on: The query results are displayed both in the spool file and in the Sqlplus;Set term off:
We mentioned before that when you forget the password of a website, you can try the Universal password: Username input Admin '--this is actually exploited SQL injection vulnerability.SQL injection (SQL injection): An attacker who destroys the
The way I execute the INSERT statement is
function Execute_data ($sql) {$result = @mysql_query ($sql) or Die (Mysql_error ()), @mysql_free_result ($result) or Die ( Mysql_error ()); return $result;}
$sql = "INSERT into test (name)
Oracle Oracle's Sql*plus is a client tool that interacts with Oracle. In Sql*plus, you can run the Sql*plus command and the Sql*plus statement.
Our usual DML, DDL, and DCL statements are sql*plus statements that, when executed, can be stored in an
Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement. The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.