12-02-2008
In this case all lines in the shell script up to the first line starting with the exclamation mark will be read by sqlplus. The exclamation mark itself is just a string rather than any particular syntax. It is conventional to use "EOF" or "EOSQL" but exclamation mark will do. Beware that any $ signs in SQL syntax will have to be escaped as \$ .
sqlplus -s username/password <<EOF
SQL commands go here.
EOF
More shell commands
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can i use the shell script like this? When i am running the script it is hanging not giving me any output. I can redirect the output and then i can do the manipulations also but why this one is wrong. I am confused we can do like this or not..
#!/usr/bin/ksh
for line in `top`
do... (2 Replies)
Discussion started by: namishtiwari
2 Replies
2. UNIX for Advanced & Expert Users
in my parition i hav parition like this
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 24G 22G 756M 97% /
/dev/sda5 248G 1.2G 234G 1% /else
/dev/sda1 965M 24M 892M 3% /boot
tmpfs 7.0G 0 7.0G 0%... (1 Reply)
Discussion started by: ponmuthu
1 Replies
3. UNIX for Dummies Questions & Answers
Hi ,
Struck with one basic question.
Iam expecting word count of 4 where "wc" is showing as 5 .
# echo "abcd" | wc
1 1 5
# echo abcd | wc
1 1 5 (5 Replies)
Discussion started by: penchal_boddu
5 Replies
4. Shell Programming and Scripting
Hi,
I have a file with multiple entries and I have calculated the percentages. Now I want to know how many of my entries are there between 1-10% 11-20% and so on..
chr1_14401_14450 0.211954217888936
chr1_14451_14500 1.90758796100042
chr1_14501_14550 4.02713013988978... (1 Reply)
Discussion started by: Diya123
1 Replies
5. Red Hat
How to create a file with specific size in RHEL6 (1 Reply)
Discussion started by: Sashi Kanth A
1 Replies
6. Shell Programming and Scripting
Hi experts,
In one of our code we have used some command like this.
name=${name##*/}
Can someone please let me know what exactly it does?
Thanks & Regards,
Sathya V. (1 Reply)
Discussion started by: Sathya83aa
1 Replies
7. UNIX for Beginners Questions & Answers
in my shell script requirement is to search and replace the file with variable so i use the following command sed -i "s/abc/$SCHEMA/g" table.sql
later when the script runs sqlplus username/pwd@Table& this & is not letting the variable to replace the value inside the file .please let me know... (1 Reply)
Discussion started by: bhuvan1
1 Replies
LEARN ABOUT X11R4
gshadow
GSHADOW(5) File Formats and Conversions GSHADOW(5)
NAME
gshadow - shadowed group file
DESCRIPTION
/etc/gshadow contains the shadowed information for group accounts.
This file must not be readable by regular users if password security is to be maintained.
Each line of this file contains the following colon-separated fields:
group name
It must be a valid group name, which exist on the system.
encrypted password
Refer to crypt(3) for details on how this string is interpreted.
If the password field contains some string that is not a valid result of crypt(3), for instance ! or *, users will not be able to use a
unix password to access the group (but group members do not need the password).
The password is used when a user who is not a member of the group wants to gain the permissions of this group (see newgrp(1)).
This field may be empty, in which case only the group members can gain the group permissions.
A password field which starts with an exclamation mark means that the password is locked. The remaining characters on the line
represent the password field before the password was locked.
This password supersedes any password specified in /etc/group.
administrators
It must be a comma-separated list of user names.
Administrators can change the password or the members of the group.
Administrators also have the same permissions as the members (see below).
members
It must be a comma-separated list of user names.
Members can access the group without being prompted for a password.
You should use the same list of users as in /etc/group.
FILES
/etc/group
Group account information.
/etc/gshadow
Secure group account information.
SEE ALSO
gpasswd(5), group(5), grpck(8), grpconv(8), newgrp(1).
shadow-utils 4.5 01/25/2018 GSHADOW(5)