Search Results

Use a '#' sign for sed delimiter instead of a '/':
echo RUNDATE | sed "s#RUNDATE#$NOW#g"

What's your system? Not all systems support a regex for awk's field separator. GNU awk does, few others do.

You can do this in any Bourne shell:

USERDATE="2012/09/19 00:00:00"

IFS=":/ "...

Perform a left outer join of your cursor with table2 on the conditions specified in my earlier post. Use the nvl2 function to fill in "gaps" in rep_id column.

tyler_durden

Here's an update statement that should do the trick -


SQL>
SQL> -- Before update
SQL> select * from table1;

DEPT_ID DEPT_NAME REP_ID ADMIN_LASTNAME
----------...

Something like this:

update <table_name>
set amount = 0
where rowid != (
select max(rowid)
from <table_name> a
where t.id = a.id
and t.amount = a.amount
);
For...

Then all you have to do is separate the numeric regular expression from the one that is null by a vertical bar...
if [[ "$var" = ?(""|*([+-])*([0-9])*(.)*([0-9])) ]]; then

The problem with your expression is that the number may contain a + and/or a decimal point or it may not but you arent making that clear to ksh so how about a simpler regular expression like...
...

$
$
$ # Here's my Oracle SQL script
$
$ cat -n myscript.sql
1 set verify off feed off time off timing off
2 declare
3 v1 varchar2(10);
4 v2 varchar2(10);
5...