Shulou(Shulou.com)05/31 Report--

How to transfer shell script variables and sqlplus variables to oracle database. In view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

1.1 the system collects data into oracle database

1. For example, query

#! / bin/sh

Astatine 1

B = `date +% Y% m`

If [- z $1]; then

Echo "Usage: $0a"

Exit 0

Fi

Sqlplus user/password

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.