Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number of Rows Created in CTAS across DBLINK
> When I create a table TARGET as
>
> CREATE TABLE TARGET AS SELECT * FROM SOURCE_at_DBLINK1
>
> where SOURCE is a view in a remote system, how do I find out how many
> rows were created?
How about:
SELECT COUNT(*) FROM TARGET; That should do the trick!!! The solution proposed by mcstock is also a more elegant one for PL/SQL.
Cheers,
Brian
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Nov 10 2003 - 09:38:21 CST