E-Business Suite

Blog consists of oracle ebusiness suite code

Monday, 19 January 2015

To find the table name by using the column name

To find the table name by using the column name:

select * from all_tab_columns where Upper(column_name) like Upper('Payment%Method%');

Payment%Method% is the column name
Posted by Unknown at 06:44
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ►  2017 (2)
    • ►  August (1)
    • ►  July (1)
  • ►  2016 (9)
    • ►  October (1)
    • ►  September (1)
    • ►  July (3)
    • ►  April (1)
    • ►  February (2)
    • ►  January (1)
  • ▼  2015 (16)
    • ►  December (2)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  February (7)
    • ▼  January (4)
      • Use of system administrator request Groups and res...
      • Code with substr and instr in oracle apps r12
      • To find the table name by using the column name
      • for my use - unix send mail program with output at...
  • ►  2014 (21)
    • ►  December (2)
    • ►  November (6)
    • ►  October (2)
    • ►  September (1)
    • ►  August (8)
    • ►  March (2)
Ethereal theme. Powered by Blogger.