Home » SQL & PL/SQL » SQL & PL/SQL » SQL Question
SQL Question [message #228313] Mon, 02 April 2007 09:23 Go to next message
Michael GIllespie
Messages: 8
Registered: January 2004
Junior Member
I have sql returning a list of tables for a user. I would like to omit the bin$ tables which I guess are the flashback tables. Is it safe just to use a instr or like? Or is there a better way?
Re: SQL Question [message #228314 is a reply to message #228313] Mon, 02 April 2007 09:26 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
use a filter on the DROPPED column of all_tables

These tables are dropped, but still in the recycle bin.

[Updated on: Mon, 02 April 2007 09:26]

Report message to a moderator

Re: SQL Question [message #228317 is a reply to message #228314] Mon, 02 April 2007 09:33 Go to previous message
Michael GIllespie
Messages: 8
Registered: January 2004
Junior Member
Thanks for the fast response.
Previous Topic: inner join with system tables takes too long!!!!!!!
Next Topic: time format
Goto Forum:
  


Current Time: Tue Dec 06 10:15:36 CST 2016

Total time taken to generate the page: 0.08604 seconds