query to select all tables from database but not materialized views

I am selecting all tables from database by using query

select table_name from all_tables where owner='XYZ' order by table_name

But above query is also returning materialized view. How can I get only tables and not materialized view

Answers


you can ignore the materialized views and their log tables (if they exist) with

select *
  from all_tables t
 where owner = user
   and (owner, table_name) not in (select owner, mview_name
                                     from all_mviews l
                                   union all
                                   select log_owner, log_table
                                     from all_mview_logs)

Need Your Help

How do I access all of the children of a DisplayObject programatically?

actionscript-3 actionscript flash-cs5 displayobject

How do access all of the children of a DisplayObject using code? (I'm looking for something like movieclip.children)

Only one instance of a ScriptManager can be added to the page: issue with Ajax Toolkit?

asp.net visual-studio-2012 master-pages scriptmanager toolkitscriptmanager

I am on visual studio 2012. I need to add in the CollapsablePanelExtender for my site. Because there is a ScriptManager on the MasterPage, I cannot figure out how I can add in the ToolkitScriptMana...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.