Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 15 Vote(s) - 2.73 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Materialized view in oracle r12
#1
What is materialized view and how to create
it in oracle r12?
Reply
Thanks given by:
#2
A materialized view is a database object that contains the results of a query.
The FROM clause of the query can name tables, views, and other
materialized views. Collectively these objects are called master tables (a replication term) or detail
tables (a data warehousing term). This reference uses "master tables" for
consistency. The databases containing the master tables are called the master databases.
thank you
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Oracle Subledger Accounting new Features in EBS Release R12 Sneha Rahul 0 535 05-28-2017, 08:06 PM
Last Post: Sneha Rahul
  Payments to Financing House In Oracle R12 nisarwangde 1 580 12-12-2016, 07:17 PM
Last Post: nisarwangde
  Supplier Creation R12 on Windows 10 RANDHIR KALLEECHURN 2 940 10-17-2016, 07:00 PM
Last Post: RANDHIR KALLEECHURN
  How to Import Journals in Oracle R12 KaleemTG 2 2,267 03-10-2016, 03:20 AM
Last Post: Sifeddine
  R12 Oracle Property Manager MKardaris 0 1,617 10-17-2015, 02:00 AM
Last Post: MKardaris
  Invoice having too many lines in AP r12 Harish Duleep 2 1,320 09-26-2015, 02:11 PM
Last Post: rajagopal_23
  R12.1.3 BR100 Documents Needed sroyle 16 17,106 08-04-2015, 10:42 PM
Last Post: admin
  How can we delete some transactions from Oracle applications R12 Archita Jartin 0 1,775 06-11-2015, 03:48 AM
Last Post: Archita Jartin
  How we can bring AP Invoice attachments through the FA Mass Additions Process in R12 Saleem Akhtar 1 1,611 03-23-2015, 07:40 PM
Last Post: ajkhan80
  User record updated by Anonymous in oracle r12 Ahmad Mujeeb 1 3,641 03-18-2015, 07:28 PM
Last Post: Divya Omkar



Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!