Re: PL SQL developer display user tables that are not empty
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 26 Nov 2007 08:23:59 -0800
Message-ID: <1196094232.187445_at_bubbleator.drizzle.com>
Date: Mon, 26 Nov 2007 08:23:59 -0800
Message-ID: <1196094232.187445_at_bubbleator.drizzle.com>
noelloen wrote:
> Hi
>
> How can i display user tables that are not empty using PL SQL
> developer? or
> How can i display user tables that are empty using PL SQL developer?
>
> thanks
Define "display"?
desc <table_name>
SELECT *
FROM <table_name>;
PS: Any question you ask here should contain a version number.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Nov 26 2007 - 17:23:59 CET