This section briefly describes five data types in SQL: numeric, text, numeric, logical, and date.
Character Type
Varchar and char
The differences between varchar and char data are subtle, but important. They are used to store strings of less than 255
Decimal (numeric) synonymous for precise storage of numeric valuesfloat and real cannot store values accuratelyThe decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type
JS Check is a numeric function and a non-empty functionCheck to see if it is not emptyfunction Notempty (obj, msg){str = Obj.value;STR1 = "";for (i = 0; i {if (Str.charat (i)!= ""){STR1 = Str.substr (i, str.length);Break}}if (str1 = ""){Alert
Requirements:
If the field value is not a numeric or numeric string, update the field value''
1. Function Method (batch release is not allowed ):
create or replace function isNumber(p_in varchar2) return boolean as i
Requirements:
If the field value is not a numeric or numeric string, update the field value''
1. Function Method (batch release is not allowed ):[SQL]
CreateOrReplaceFunctionIsNumber (p_in varchar2)ReturnBooleanAs
I number;
Begin
I: = to_number
One or two binary and octal notation1. ES6 provides a new notation for binary and octal values, respectively, with a prefix 0b (or 0B ) and/ 0o or 0O .2. Use the method if you want to convert 0b 0o The string value of the prefix to decimal Number
---DQL: Data query statementsThe---Select statement must contain at least two words, namely the Select and from words.---the SELECT clause to specify the field to query.---the table that the FROM clause uses to customize the data source. The--select
To see this problem, it should be very simple at first, and there are more ways than one.
Online check, most of the people are using Is_numeric method, but also often follow a sentence, do not think too complex, balabala ...
I did the next test,
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.