Search Results

I have a date that is received as text in Jan 1 2002 12:00AM format. Can anyone give me any ideas how to format that in oracle format i.e. 01-JAN-02

Found it

sqlplus /nolog
connect username/password@db

Any have know how to hide the user/password paramters when doing a ps -ef when running
sqlplus username/password@db from a script.

I'm creating an oracle insert statement using awk but need to be able to escape the ' (forward single quote) as the oralce insert syntax requires these quotes. I've tried \ in and out of quotes etc....

when declaring a variable e.g.
export DAYS

what checking / how can i check that the value assigned only contains numeric characters or integers ?