Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [user@centos ~]$ cat db_object.list
- BOX,FUNCTION,BASE_TO_LOCAL_TIME
- BOX,FUNCTION,LOCAL_TO_BASE_TIME
- [user@centos ~]$ cat 2spool.awk
- BEGIN { FS = "," }
- {
- FILE_EXT=".sql";
- if ( $2 == "FUNCTION" ){
- FILE_EXT=".fnc"
- } else if ( $2 == "PROCEDURE" ){
- FILE_EXT=".prc"
- } else if ( $2 == "PACKAGE" ){
- FILE_EXT=".pks"
- } else if ( $2 =="PACKAGE BODY" ){
- FILE_EXT=".pkb"
- } else if ( $2 == "TRIGGER" ){
- FILE_EXT=".trg"
- }
- print "1 " $2
- print "2 " FILE_EXT
- SPOOL_FILENAME=$1 "." $3 FILE_EXT
- print "3 " SPOOL_FILENAME
- #fflush()
- #print "spool off;"
- }
- END { print "exit;" }
- [user@centos ~]$ awk -f 2spool.awk db_object.list
- 1 FUNCTION
- 2 .fnc
- .fncX.BASE_TO_LOCAL_TIME
- 1 FUNCTION
- 2 .fnc
- .fncX.LOCAL_TO_BASE_TIME
- exit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement