Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> query
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
![]() |
![]() |