Let's take a look at the simple initial code: Pay attention to the compiled and running results.
Root @ xuanfei-desktop :~ /Cpropram/2 # Cat global. h // header file# Ifndef clobal_h# Define global_h# Include Int funca (void );Int funcb (void );#
Classification of functions :1, single-line function: For each record input value to calculate, obtains the corresponding calculation result, returns to the user, namely, each record as an input parameter, after the function computation obtains each
In php, the magic constants _ FILE _, _ LINE _ ,__ FUNCTION _ are used. This article mainly describes the magic constants _ FILE _, _ LINE _ ,__ FUNCTION __. if you need them, you can refer to a simple and practical example. Name Description _ FILE _
Single-line function: For each row of data to be calculated after a row of output results,SQL single-line functions are divided into character functions, numeric functions, date functions, conversion functions, and other general functions based on
Reference: http://docs.oracle.com/database/122/SQLRF/Functions.htm#SQLRF006Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE clauses, and START WITH CONNECT BY
Single line function
A function is the same as the functionality of a method in the Java language to perform functional support for certain operations. And now the Oracle database weight also contains a large number of single-line functions,
Single-line function syntax:Function name (COLUMN|EXPRESSION,[ARG1,ARG2,...] )Parameter description:Function name: Names of functionsColumn: Database columns nameExpression: string or computer expressionsARG1,ARG2: Using Parameters in
I. Overview What is a single-line function:Action data Object Accept parameter returns a result only one row is transformed each row returns a result that can be transformed data types can be nested parameters can be a column or a value For
Oracle_ Multi-line function
Multiline function min (), Max (), count (), SUM (), AVG ()
--1.1 Statistics of the company's maximum wage, minimum wage and total number --for null values to skip directly, do not operate--max,
Syntax for single-line functionsFunction_name (Column|expression, [Arg1, Arg2, ...])Parameter description:Function_name Function NameColumn NameExpression ExpressionsArg1,arg2,... ParametersSingle-line function classification:
Character
OpenGL Draw Line functionA graphics package typically provides a function that describes one or more line segments, where each line segment consists of two endpoint coordinate bits defined. In OpenGL, as with selecting a point location, we use the
single-line function : Only one parameter input, only one result outputMultiline function or grouping function : can have multiple parameter inputs, only one result outputTest lower/upper/initcap function, use dual dummy tableSelect lower ('
Single-line function①. Character functionsLOWER (x): Converts each word in X to lowercaseUPPER (x): Converts each word in X to uppercaseInitcap (x): Converts the first letter of each word in X to uppercaseCONCAT (x, y): Used to add y to X, with |
single-line functionWhole the essence of SQL:Select statement + single-line function (back)String FunctionsThe usual functions for working with strings are as follows :
No.
Name of function
Meaning
1
UPPER (
Although each database is supported by SQL statements, each database has its own operation function supported by each database, which is a single-line function, and if you want to do database development, except to use SQL, is to learn more
Single-line function the first part 1th numeric function--1 Create a user-specified tablespace--1.1 view the current tablespace state col tablespace_name for a15; col file_name for a50;
Simple function:For example: Now you want letters to be capitalized. Such a function can be done using a single-line function.Core of several.String functions, numeric functions, date functions, conversion functions, general functions.Requires the
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.