On the Oracle SQL prompt type
delete user testuser cascade;
This blog is for and about myself, friends .. et al
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Feb | ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 | |||
On the Oracle SQL prompt type
delete user testuser cascade;
awk ‘($1 ~ /[^ ]+/){print $0}’ filename.txt
Where filename.txt is the name of the file you want to remove the empty lines from.
Funny how the while loop is sensitive to spacing around the square brackets. An extra space before, or within the bracket, then you get an error.