SQL Script for select data from ebs and make a csv file to FTP, ebscsv
Declare cursor cur_lcy_test is select rcta. customer_trx_id, rcta. trx_number, rcta. trx_date FROM ra_customer_trx_all rcta WHERE rcta. customer_trx_id = 11993; -- rec_lcy_test cur_lcy_test % ROWTYPE; -- Comment NUMBER: = 0; TYPE comment is table of VARCHAR2 (4000) index by BINARY_INTEGER; w_rec_data comment; w_separator VARCHAR2 (1 ): =
executed under the current connection, if no error returns 0.@ @FETCH_STATUS: Used in conjunction with the FETCH statement.@ @IDENTITY: Returns the automatically generated identity value of the last sentence running the statement as the result of the last insert or SELECT INTO statement.@ @ROWCOUNT: Returns the number of rows affected by the last statement.@ @SERVERNAME: Returns the name of the local service on which the script is running.@ @TRANCOUN
VBS scripts and BAT batch processing methods for self-deletion (suicide)
Delete itself: VBS
Save the following script as selfkill. vbs or selfkill. vbe:
Copy codeThe Code is as follows: Set fso = CreateObject ("Scripting. FileSystemObject ")
F = fso. DeleteFile (WScript. ScriptName)
WScript. Echo (WScript. ScriptName)
Then run it. Did you find selfkill. vbs suddenly disappeared? The subsequent dialog box is
Shell) is a powerful network configuration command-line tool provided by the Windows system itself. Export configuration script: Netsh-c interface IP dump > C:\interface.txt import configuration script: Netsh-f c:\interface.txt.Dump: Display a configuration scriptAdd: Adds a configuration item to the list of items.
netsh-c int IP dump > c:\ip.txtThis command displays the interface IP configuration for the
There are a lot of open source batch deployment tools that can be used, such as puppet, Ansible, Saltstack, chef.But these tools have their own set of grammar rules, you have to follow his syntax to write programs, and then batch execution.Is there a way to write bash or Python scripts directly and then execute them in batches?The method of course is that you need to write your own program to transfer scrip
#!/bin/bashFor user in ' Cat/home/opt/userlist.txt 'DoMkdir-p/app/ftp/issue/merdealfiles/$user/dealfilesMkdir-p/app/ftp/issue/merdealfiles/$user/dealfiles/applyareaMkdir-p/app/ftp/issue/merdealfiles/$user/dealfiles/resultareaMkdir-p/app/ftp/issue/merdealfiles/$user/dealfiles/checkfileschmod 770/app/
Comparison between Shell script commands and DOS batch processing commands-Linux general technology-Linux technology and application information. The following is a detailed description. [I = s] This post was last edited by lijiang at, January 10 ,.
,
In fact, the defective DOS batch processing file language can still write some powerful scripts, although they g
Background: Batch execution of commands for Linux servers and batch sending of files is the most fundamental part of the operations automation process, and this script is the implementation of this function, and the shell can also implement similar functions through expect.This script uses the Pexpect module, without w
When we are doing development on window, we may need to develop two or more projects at the same time, and sometimes different projects will differ on the JDK version requirements, when we may install multiple versions of the JDK on a single computer, as shown in: When we want to switch between the JDK versions we use, we can do two things:1. To manually modify the JAVA_HOME environment variable, point the value of the variable to the installation directory of the corresponding JDK version.2. I
command to start or stop various sqlserver services, such: Net start SQLAgent $ sql2005de1
/*
Start the SQLAgent service in instance sql2005de1
*/ Net stop SQLAgent $ sql2005de1
/*
Stop the SQLAgent service in instance sql2005de1
*/
According to the net command, you can write a batch processing script to start various services of each instance. CopyCodeTo store the "Start stopsqlserver. Bat
When deploying a task, one of the necessary processes is to send some files, such as the installation package, to a large number of servers. Although yuge's script is available, it is a python script written through the ssh and scp functions provided by the paramiko module. But now I am still in fear of python (although I have tried to learn it in my spare time), so I used a combination of shell and CT scri
file.D. bat batch Implementation start MongoDB scriptMongoDB Install bin path D:\Program files\mongodb\bin,mongodb in Data folder D:\Program Files\mongodb\data We should be like this in the cmd command window, start the MongoDB database CD D:\Program files\mongodb\bin
mongod --depath "D:\Program files\mongodb\data" But every time we have to knock on these, it really makes us very troublesome, so we can use bat's just to do such a bat file: :: Indic
In a UNIX system environment, you can use a variety of Unix shells combined with cron tasks to achieve automatic backup of MySQL, that under Windows How to implement it, It's very simple. Just write a custom batch script in conjunction with Taskschd.msc (Task Scheduler), you can implement, recently need to modify the tuning Windows environment of MySQL in the way to write a logical backup using mysqldump
You have to run so hard to look back at people crawling.
Laziness is also needed to learn.
On their own blind, may even "this piece can be lazy" consciousness is not, once absorbed in other people's thinking, the next is much simpler
Do not wait for people to teach, do not wait for the "training", will lazy are lazy people, you do not take the practice of the specific problems encountered in the initiative to ask, they do not bother you
Split it! Sp
SQL server script and batch processing command summary. If you are studying SQL Server, you can add it to your favorites.
SQL server script and batch processing command summary. If you are studying SQL Server, you can add it to your favorites.
I. Script Basics1. USE state
#! /bin/bashAction () {#1, get SVN update output/OPT/SVN/SVN/BIN/SVN update/opt/lampz/apache/web > File_out#2, gets the number of rows through the output file File_outline=$ (wc-l File_out|awk ' {print $} ')#3, if the number of rows is greater than 2, there is an update or delete operation to get a list of files that need to be deleted or updatedif [[$line > 2]];thenEgrep-v ' Updating| updated| At ' file_out|egrep ' ^d ' |awk ' {print $} ' |awk-f ' web ' {print $} ' >file_delete #删除的文件列表Egrep-v
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.