Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Oracle SQL RTFM question



I've got a shell script where I need to embed some Oracle commands. What I
need to do among other things is to see if a user does not exist, and create
a user.
Sqlplus user/pwd @commands.sql
In the commands file:
Select username from users like '%fubar%'
If username does not exist then
Create user ...;

I know how to create a user, grant, et.al, but I don't know how to set this
up to test if a user exists.





BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org