Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> query

query

From: <rc370_at_columbia.edu>
Date: Wed, 17 Mar 1999 00:14:50 -0500
Message-ID: <36EF3A4A.885A1168@columbia.edu>


Can some help me turn this into a correlated subquery

Update abc_tables set(
 TABLE_NAME, DATE_MODIFIED, OWNER_NAME, NBR_OF_COLUMNS) = select table_name, sysdate, owner, count(*) from all_tab_columns group by owner,
table_name;

i appreciate any input anyone can give me Received on Tue Mar 16 1999 - 23:14:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US