What is the difference between Views and Materialized Views in Oracle?

-
Materialized views are disk based and update periodically base upon the query definition.

Views are virtual only and run the query definition each time they are accessed.

Comments

Post a Comment

Popular posts from this blog

Delete Blank Columns From The Excel

-
Following VBA Code will delete blank columns by ignoring 1st row (i.e header) in the excel Steps to follow 1. Open New Excel Workbook 2. Press Alt+F11 3 Click Insert-->Modue 4. Copy and paste the below code in the Blank module inserted from above step 3 5. Click on the Save button or press Ctrl+S 6. Save the excel workbook in ".xlsm" OR "Macro-Enabled Workbook" format. How to Use this Macro-Enabled WorkBook 1. Open the Macro-Enabled Workbook (eg: "delete_column.xlsm") 2. Copy-paste the data (including header) which contains blank columns. Note: If your data doesn't have a header row then replace the following line of code If Application.WorksheetFunction.CountA(Rng.Columns(Col).EntireColumn) =0 Then 3. Navigate to View in the Menu Bar 4. Select drop down from the Macros Icon--> View Macros 5. Ensure macro name "DeleteROPBlanks" is selected and macros in selected as (eg: "delete_column.xlsm") 6. Hit Run button 7. You can observ...
Read more

Steps to Deploy the OFSAA application in WEBLOGIC server:

-
Steps to Deploy the OFSAA application in WEBLOGIC server: ========================================================= 1) Generate the "context_name.ear" from the FIC_WEB area by executing the ./ant.sh 2) Create a folder by the name "applications" within the domain directory 3) Create a folder by the name "context_name.ear" within the newly created "applications" folder 4) Copy the context_name.ear file from the FIC_WEB folder to the newly create the "context_name.ear" folder created within the applciations folder 5) Explode the .ear file copied from the FIC_WEB area (jar -xvf context_name.ear), There are 2 files and 1 directory created after the .ear file is exploded as mentioned below a) context_name.war ---> file b) context_name.ear ---> file c) META_INF ---> folder 6) Delete the above files (.ear and .war files) 7) Create a new folder by the name "context_name.war" 8) Copy the context_name.war file from th...
Read more