Several cases of sqlplus and shell passing value to each otherScenario One: The simplest invocation of sqlplus in the shell$cat test.sh#!/bin/shSqlplus Oracle/[email Protected]>file.log SELECT * from Test;ExitEOF #注意EOF要顶格写$sh test.sh$cat
1. Find in the -exec Parametersin the current directory ( including subdirectories ), find all txt files and find the string "Bin" containing the the lineFind./-name "*.txt"-exec grep "bin" {} \;in the current directory ( including subdirectories
A sample shell script:Gets all file names, paths, and file sizes under the directory (including subdirectories).Code, Shell script: lsdir.sh#!/bin/bash# #site: www.jquerycn.cnfunction ergodic () { forFileinch' LS $1` Do if[-D $1"/"$file] then
Some time ago in the study shell script, the last mention of the SED mode space and maintain the concept of space, but has not studied well, these two days studied, so it sent, not very comprehensive, just for your reference.Keep the space sed under
In the recent work, the product group of colleagues to give the data are all lowercase letters, but the engine team colleagues asked them to get from the data inside the structure of the analysis is all capitalized structure, which makes our data
Background:A lot of people have been converted from C + +, after reading the study document, stepping into a lot of pits1 assigning values to variables don't have spaces# correct a = 123 # error2 if statement [] to leave a space, the variable is
Use the SET command to set various shell options or to list shell variables. A single option sets commonly used attributes. After some options, the-o parameter opens special properties. After some options use +The o parameter will turn off some
The line end flags for Linux and Windows text files are different. In Linux, the text file uses "/n" for carriage return, while Windows uses "/r/n" to indicate carriage return line breaks. Sometimes you need to be aware of this when writing shell
The color of the text terminal can be generated by using the ANSI unconventional character sequence. Example:Echo-e "\033[44;37;5m ME \033[0m COOL"The above command sets the background to blue, foreground white, blinking cursor, output character "ME"
First, the name of the variableThe variable name must begin with a letter or underscore, consisting of a letter, number, or underscore, and the variable name cannot exceed 255 characters in length.Ii. Classification of variables1. User-defined
#!/bin/bash################################ System Condition Analysis Script ## ##用途: For system CPU usage, memory, ##网络连接, disk space, System process ##交易数量以及交易日志进行分析 ##适用操作系统: Linux ##版本: 1.0 ##
Three days of writing edge test, and finally completed the current longest code script, a total of 253 lines, in 2 machine installation Lamp,lnmp have passed smoothly, the script can be used as a production environment.Where the script needs
Determine how long the Linux file has been modified to perform actionsCreate a scriptvi/var/tomcat/find.sh#!/bin/bashA= ' stat-c%y/var/tomcat/logs/catalina.out ' //Get File modification time (in seconds)b= ' Date +%s ' //time to get the current
1. What is Shell scriptshell script is to use the shell's function to write a "program", the program is to use a plain text file, some shell syntax and commands (including external commands) written inside, with regular expressions, Pipeline command
First, view the file encoding. When you open the file, enter: Set fileencodingYou can display the file encoding format. Second, the file encoding conversion1, in vim Direct conversion file encoding, such as converting a file to Utf-8 formatin the
1. Definition:The crontab command is commonly used in Unix-and Unix-like operating systems to set instructions that are executed periodically. The command reads the instruction from the standard input device and stores it in a "crontab" file for
Problem descriptionFor Linux systems, many times are used for servers and the like, this time is not open desktop system, so that the command line operation, can effectively save the use of system RAM, so that as many resources as possible for the
1.shell IntroductionThe shell itself is a program written in C, which is a bridge for users to use Linux. The shell is both a command language and a programming language. As a command language, it interprets and executes user-entered commands
Fly2015For FSG shells. No previous contact was the first contact. This time to take the shelling process is still my love to crack the forum to crack the training of the Operation 3 program. For this shell toss for a while, and later was taken care
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