This article describes the typical examples that sql*loader often use in the process of actual use.
1. How do I get fewer columns for the larger than data file in the table?
Suppose a CSV file is as follows:
A1,A2,A3,A4
b1,b2,b3,b4
c1,c2,c3,c4
d1,d2,d3,d4
A total of 4 columns, the first request as long as the 2nd, 3 columns of data, how to do? At this point, the filler (note: not the filter) parameter comes in handy, the control file looks
Example 2: Define and output array elements by script:
[Root@oldboy scripts]# Cat printarray.sh
Dir= ($ (ls.))
for ((i=0; i
Todo
Echo-e "${dir[$i]}\n"
Done
[Root@oldboy scripts]# SH printarray.sh
Oldboy.log
apachemon.sh
Httpdctl
printarray.sh
====================================================
2) Method Two: Enumerating Element method
array= (red green blue Yellow magenta)
Array= (
Oldboy
Zhangyue
Zhangyang
)
Example 3: Scripting examp
Getting Started with C # reflection first understand that C # reflection provides an object that encapsulates assemblies, modules, and types, and so on. So you can use reflection to dynamically create an instance of a type, bind a type to an existing object, or get a type from an existing object and call its methods or access its fields and properties. If you use attributes in your code, you can use reflection to access them.
One of the simplest examples
follows:
The disadvantage of the method is that there is no div tag under the div for the content block. Method Four: Do not use JS, with "input:checked" To do the tab switch, first of all the content hidden, the contents of the selected display. The code is as follows:
The disadvantage of the modified method is that different regions can be switched only by clicking.
Several different tab-switching examples
first, imitation of the "Re
The examples in this article describe a variety of common uses of JavaScript arrays. Share to everyone for your reference. Specifically as follows:
The effect is as shown in the following illustration:
The specific code is as follows:
The wants this article to help you with your JavaScript programming.
A) Sort function usage
Sort LISTSort Block LISTSort SubName LIST
The use of sort is in the form of 3 different forms. It sorts the list and returns the sorted lists. If SubName or Block,sort are omitted in the standard string comparison order (for example, ASCII order). If SubName is specified, it is actually the name of a child function that compares 2 list elements and returns an integer less than, equal to, or greater than 0, depending on the order in which the elements are sorted (ascendin
This example describes the use of JavaScript text templates. Share to everyone for your reference. Specifically as follows:
This is my reference prism.js algorithm to write a small function, nothing to say, as a program ape to see examples should understand seconds.
String template Engine class:
/*class*/stringtemplate = function (/
* Optional {patt:regexp, clpatt:regexp}*/pattern) {
if (!!) Pattern) {
This.patt = Pattern.patt;
Thi
() *),
rowchecksum as COALESCE ( CHECKSUM (ID, num), 0) PERSISTED PRIMARY KEY
Here are some more useful examples: First, take a look at the use of this function from MSDN, the COALESCE function (hereinafter referred to as the function), return a parameter Non-null value. such as:
Because all two parameters are null, the value of the GETDATE () function is returned, which is the current time. Returns the first Non-null va
This article mainly introduces the session cycle of the ZF framework and the number of restrictions used examples, the need for friends can refer to theThe code is as follows:
The style of web design is varied, but the illustration wind is never outdated. Illustrations allow designers to express their own rich creativity and imagination, the use of illustrations in the design will make the Web page become more interesting. Today we have collected 15 examples of web design cases using illustrations to feel the creativity of these designers.
Abby Putinski
Activate Media
Awesome Fantasy comic book Ad
This article mainly introduces JavaScript using HTML5 Window.postmessage to implement Cross-domain communication examples, you need friends can refer to the following JavaScript has been a thorny issue because of the limitations of homology policies. Of course, the solution also has a lot of:nbsp; 1.document.domain+iframe settings, applied to the primary domain the same and subdomains different;nbsp; 2. With IFrame and Location.hash, data is exposed
/-atime 5028. Find all files that have been modified within 50-100 days# Find/-mtime +50–mtime-10029. Find all files changed within 1 hours# Find/-cmin-6030. Find all files modified within 1 hours# Find/-mmin-6031. Find all the files accessed within 1 hours# Find/-amin-6032. Find all files of length 50MB# Find/-size 50M33. Find all files of length in 50MB-100MB# Find/-size +50m-size-100m34. Find and delete all files larger than 100MB# Find/-size +100m-exec rm-rf {} \;35. Find all files that are
the Linux file system has three timestampsAccess Time (-atime): The last time a user accessed a file;Modification Time (-mtime): The time the file content was last modified.Change Time (-ctime): The time the file metadata (metadata, such as permissions or ownership) was last changed.-atime,-mtime,-ctime as the time parameter, the unit is day. You can use + to represent greater than,-represent less than (and the same as +,-based on file size lookups).1) Find./-mtime-5 finds files that have been
device, and the output file to write the floppy image file name as shown below.[email protected] ~]# DD if=/dev/fd0 of=myfloppy.imgExample 5: Backing up a partitionUse the DD command to back up the hard disk partition. Enter the file to fill in the partition's device name, and the output file to fill in the target path or image file you specified. The DD command example shows the following:[email protected] ~]# DD if=/dev/sda1 of=~/partition1.imgExample 6: Disc backupThe DD command allows us to
something else.Export_symbol (name); The function of the module can be exported, which is also the final purpose of the module writing...When it comes to Insmod and Modinfo. You should think of something else.Depmod analysis can load the dependencies of the module and generate MODULES.DEP files and mapping filesModprobe Linux kernel Add Delete module...If you want to become a professional Linux module developers, but also to go a lot of ways to see you, I wish you all good learning.I am not a L
In-depth understanding of Linux, this aspect of the content is not small, this period of time to fill in.#include Examples of direct system calls and calls through C libraries in Linux
shell script : hello.sh#!/bin/bashecho"I am in shell script"echo"param 1 is'echo'param 2is $"variable=$[$1 + $2 ]echo"sum is $variable"System Interface : SYSTEM.C#include void main (void) { printf ("I am in C code!\r\n" System ("/bin/bash"). /hello.sh); }Output : in C code! in Shell script! 1 is 2is -EXECLP interface : execlp.c#include #include#include#includevoidMainvoid){ intRET =0; intparam1 =Ten; intParam2 = -; printf ("I am in C code!\r\n"); if(fork () = =0) {printf ("execlp
************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************? time to read the file#!/bin/bashFor file in ' Ls/root 'DoStat $file >1.txtSed-n "7p" 1.txt>2.txtUsetime= awk-f ":" ' {print $2.txt} 'echo "Time=" $file $usetimeDone? reads each line of the file while statement. Cat Afile | While Read onelineDoEcho $onelineDone? reads each line of the file
Basic format:* * * * * commandTime-sharing Weekly commandThe 1th column represents minutes 1~59 per minute with * or */1The 2nd column represents the hour 1~23 (0 means 0 points)The 3rd column represents the date 1~31The 4th column represents the month 1~125th Column Identification Number Week 0~6 (0 = Sunday)6th List of commands to runSome examples of crontab files:* * * * */usr/local/etc/rc.d/lighttpd restartThe above example shows that 21:30 restar
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.