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>


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.org
Received on Mon Nov 26 2007 - 17:23:59 CET

Original text of this message