Several cases of sqlplus and shell passing value to each other

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

EXEC command in Shell

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

Shell gets all file names, paths, file sizes under 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

Shell Scripting Learning Notes (advanced usage of SED----mode space and hold space)

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

Use a Linux shell script to change the lowercase letters in the file contents of all files below the directory to uppercase

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

The shell must read at first, it is highly recommended for beginners to read

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

Shell SET Command

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

CRLF line terminators lead to Shell foot report error: Command not found

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

How to modify the output effect of the Linux shell (interface color)

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"

Shell Nginx Install + Load Balancer + Session hold

#!/bin/bash#by lc ip= ' ifconfig eth0|awk -f  ' [ :]+ '   ' NR==2{print $4} ' zhandian=/data01/static/shareextra=haixiang.conftoolsdir=/application/toolsnginxdir=/application/

Shell Learning notes-Shell variables

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

Common Monitoring System Status shell script

#!/bin/bash################################ System Condition Analysis Script ##                             ##用途: For system CPU usage, memory, ##网络连接, disk space, System process ##交易数量以及交易日志进行分析 ##适用操作系统: Linux ##版本: 1.0 ##                          

Shell script: One-click Install lamp, LNMP script

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

Shell script to determine when the Linux file modification time to perform operations

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

Bash Shell Programming Basics

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

Linxu Shell Iconv transcoding problem

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

Linux shell crontab (timed task) detailed

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

[Linux--shell] using the command line to shut down or restart

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

Shell Introduction Linux written by what language

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

Manual de-FSG shell combat

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

Total Pages: 541 1 .... 130 131 132 133 134 .... 541 Go to: GO

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.