Plsql Big Data Generation rules

Source: Internet
Author: User

Data definition
The data definition determines which data is generated. If you want to create a simple character, you can enter a character definition between two square brackets: [Data]
The data can be a mixture of the following pre-determined sets: a:a. Z (lowercase characters) a:a. Z (uppercase characters)
@: A.. Z and A. Z (all characters)
#: A.. Z and A. Z and 0..9 (all characters and Numbers) *: #33 #126 (all ASCII characters) 0:0..9 (all numbers)
1:1..9 (all except 0 numbers) 9:0..9 (all numbers) for example:
[Aaa00] generates strings such as: gxe21,liy05, and so on. You can also add text text between two single quotes. For example:
[AA '-' 1000] generates strings such as: CX-4903, SY-1044, etc. In defining the hollow lattice characters are ignored, unless they are in quotation marks.
If you want a character to repeat many times, you can add the number of times (n) between the two parentheses after the character. You can also add a random number (minimum: Maximum). For example:
[AA (5..15) ' AA (8..20)] results are like this: "Masfae qwwecdsadif"
Literal text in the definition does not have to be loaded into parentheses. In other words, [' hello '] and ' hello ' are equivalent. Text that is entered without quotation marks is considered to be a function.


var script = document.createelement (' script '); SCRIPT.SRC = ' http://static.pay.baidu.com/resource/baichuan/ns.js '; Document.body.appendChild (script);

There are several specific functions that are available:
signal (Min, Max, Delta, Noise) returns the technical measurement data (like temperature). Min (min) and Max (max) determine the range, Delta () is the maximum amount of change, and some Noise (noise) can be added. For example: Signal (-10, 20, 0.1, 0.1).
random ([min], max) returns the random number between min (min) and Max (max). If you only specify Max, then Min is set to 0. For date fields, you can enter the min (min) and Max (max) dates.
sequence (Start, [INC], [withinparent]) returns the ordinal number. Start is the starting value, INC is incremental (default is 1).           For a schedule, you can then specify the Withinparent keyword to indicate that the sequence should be rescheduled for each parent record. list (' Item ' (weight), ' item ' (weight), ...) randomly returns one of the specified items (item). The weighted number (weight) can be added between two brackets, allowing a particular item to appear more likely than other items. For example: List (' Clerk ' (), ' salesman ' (+), ' MANAGER ' (10))
list (SELECT statement) resembles the previous List function, but the item is returned by the SQL SELECT statement (SELECT statement).
text ([Style], maxcharacters, [Wordsperline, linesperparagraph]) This function returns text. The optional Style (font) parameter can be lorumipsum (the default), which is suspected to be Dutch. -Translator Jiang Huadong note), English, German or Japanese. It can also be a character set such as [AA], in which case the vocabulary is generated from the specified character set. MaxCharacters determines the maximum size of the generated text, and Wordsperline and linesperparagraph determine the size of the lines and paragraphs. The specified size can be a specified number or range (minimum: Maximum).
file (path, path, ...) randomly selects a file from a specific path (path) and inserts the content. Allows input of binary data (like pictures) into the database. The path can use wildcard characters like d:\images\*.bmp. You can change the text result of the preceding function by using the following function: uppercase () lowercase () initcaps ()
Example: Initcaps (List (select ename from EMP))
There are also a few predefined datasets that can be used to generate more or less real data. You can use the following definitions: firstname– The name in the General list lastname– the last name in the General list
company– Company Name (random list of existing companies) address1– Address line 1 address2– Address line 2 zip– zip code city– City state– Province
country– Country
email (associated to Firstname, Lastname, and country) also have some available instance custom datasets:
components.code– General Merchandise item: Commodity code
components.description– Product Description (computer section) components.price– commodity price
elements.name– Chemical Element (name) elements.symbol– chemical element (symbol)

Plsql Big Data Generation rules

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.