Single-record functions in SQL
1. ASCIIReturns the decimal number corresponding to the specified character;
SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual;
A A zero space
------------------------------------
65
Single-record functions in SQL
1.ASCII returns the decimal number corresponding to the specified character;
Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;
A A ZERO space
--------- --------- --------- ---
ModSecurity is an engine for intrusion detection and prevention. It is mainly used for Web applications and can also be called Web application firewall. it can be run as a module or a separate application of the Apache Web server. ModSecurity aims
Oracle 9i provides a number of functions that can be used to assist in data queries. Next we introduce the commonly used function function and use method.
4.5.1 "Ceil" function
In the command edit area, enter select Mgr, Mgr/100,ceil (mgr/100) from
1.SUBSTR: Find substrings in the parent stringSUBSTR (' HelloWorld ', 1,5)1: Represents the starting position of the substring, if positive, positive, negative, reciprocal5: The terminating position of the string, only the right number, can be
PL/SQL single-row functions and group functions
A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided
I. T-SQL overviewThe programming language that SQL Server uses to manipulate the database is Transaction-sql, or T-SQL. T-SQL differs from PL/SQL, and there is no fixed program structure.T-SQL consists of the following 4 sections:DDL: Define and
Modsecurity is an intrusion detection and blocking engine that is primarily used for Web applications so it can also be called a Web application firewall. It can be run as a module of the Apache Web server or as a separate application. The purpose
Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual;A A zero space------------------------------------65 97 4
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.