Ram appszone

Wednesday, 12 June 2013

query to display all the tables that contains '_' (underscore) symbol?

select *from all_objects where object_name like '%*_%' escape '*';
Posted by Unknown at 06:05 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

VISITORS

Free Web Counters
Web Site Hit Counter

Blog Archive

  • ►  2018 (1)
    • ►  March (1)
  • ►  2016 (16)
    • ►  November (2)
    • ►  June (14)
  • ►  2014 (7)
    • ►  September (5)
    • ►  August (1)
    • ►  May (1)
  • ▼  2013 (19)
    • ►  December (1)
    • ►  November (1)
    • ►  August (1)
    • ▼  June (1)
      • query to display all the tables that contains '_' ...
    • ►  May (1)
    • ►  April (13)
    • ►  March (1)
  • ►  2012 (44)
    • ►  September (1)
    • ►  August (5)
    • ►  July (3)
    • ►  June (31)
    • ►  May (4)

About Me

Unknown
View my complete profile
Picture Window theme. Powered by Blogger.