Posted byVishwa
ORACLE Export (exp) vs Datapump (expdp) ORACLE provides two external utilities to transfer database objects from one database to another database. Traditional exports (exp /imp) are introduced before 10g. Then from 10g, ORACLE introduced datapump (expdp / impdp) as an enhancement to traditional export utility. Traditional Export (exp/ imp) This is an ORACLE database […]
Posted byAdmin
ORACLE Dataguard vs Real Application Cluster (RAC) RAC and Data guard are very important topics in Oracle High Availability. Both of these architectures have many enhancements in Oracle 11gR2 than the 10g and 9i. ORACLE recommends having a combination of RAC and data guard to get the maximum benefit of data level and system […]
Posted byAdmin
Stored Procedure vs Function Stored procedures and functions are two types of programming blocks. Both of them must have calling names. Those calling names are used to call them inside another programming block like procedures functions and packages or SQL queries. Both of these object types accept parameters and perform the task behind those […]
Posted byAdmin
View vs Table Views and tables, both are two database object types. In simple words, Views are stored or named select queries. They can be created as shown below. Create or replace view view_name As Select_statement; Tables are made up of columns and rows. A column is a set of data, which belongs to […]
Posted byAdmin
View vs Stored Procedure Views and stored procedures are two types of database objects. Views are kind of stored queries, which gather data from one or more tables. Here, is the syntax to create a view create or replace view viewname as select_statement; A stored procedure is a pre compiled SQL command set, which […]
Posted byAdmin
Synonym vs Alias (in ORACLE databases) | Private synonyms and Public synonyms In English, synonym and alias have nearly the same meanings. But in databases those are two different things. Especially in ORACLE databases, both of their usage is different. Synonyms are used to refer objects of a schema or a database from another schema. So […]
Posted byAdmin
Archival vs Backup | File archiving and Database archiving, Hot backups and Cold backups Archiving and backing up are two main topics related to databases. Backups are used as a database disaster-recovery solution. Archives are used to store a specific version of a table data or a file, or separate/move a set of data, which is […]
Posted byAdmin
View vs Materialized View Views and materialized views (mviews) are two types of oracle database objects. Both of these objects refer select queries. These select queries act as virtual tables. Normally views and mviews refer large select queries, which have set of joins. Therefore, one of the main advantages of views is, we can […]
Posted byIndika
Normalization vs Denormalization Relational databases are made up of relations (related tables). Tables are made up of columns. If the tables are two large (i.e. too many columns in one table), then database anomalies can occur. If the tables are two small (i.e. database is made up of many smaller tables), it would be inefficient […]
Posted byAndrew
删除vs Truncate Both SQL (Structure Query Language) commands, Delete and Truncate are used to get rid of data stored in tables in a database. Delete is a DML (Data Manipulation Language) statement and it removes some or all the rows of a table. The ‘Where clause’ is used to specify the rows that are […]