Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem deleting file over 90 days
Try this: find */bdump/ -mame \* -mtime +90 -print -exec rm -f {} \; find */udump/ -name \* -mtime +90 -print -exec rm -f {} \; rm - r - removes the directory- Rachoor
- Post #2
- Forum: General UNIX discussion
-
SQL Script Modification - Sysdate Manipulation
May be you need to use sub query for this kind of problem. -
Comparing two tables
select cust#, date , qty, sale_price, item#, brand from t1 minus select cust#, date , qty, sale_price, item#, brand from t2 or select * from t1 minus select * from t2 when the table has duplicate rows then: select distinct cust#, date , qty, sale_price, item#, brand... -
Insert InTo Problem
Try this: Insert into tblname (Select fld1a, fld1b, fld1c, :@value4) From tblname2 valu4 may be taken as bind variable that is passed, and is constant for a transaction. -
update query in oracle
UPDATE B set (COLB, COLC) = (select COLB, COLC from A where B.COLA = A.COLA ) where b.cola = (select a.cola from a where a.COLA = b.COLA )
