bash.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 33 行

create user &username identified by student;
grant connect to &username;
grant resource to &username;
/ 


--use accept
ACCEPT username
prompt 'enter the  username:'
ACCEPT password
prompt 'enter password:'
create user &username identified by &password;
grant connect to &username;
grant resource to &username; 
/


--
#!/bin/ksh
sqlplus system/manager <<stament1
@createuser
     
stament1


accept username char prompt 'input username:'
accept password char prompt 'input password:' HIDE
create user &username identified by &password;
grant connect to &username;
grant resource to &username;
connect &username/&password;
exit