Sometimes, you would want to generate a script that you would like to run repeatedly in many environments for many objects. In such situations, use of Database Export wizard helps you generate DDL and DML (INSERT) script; – you can select object types, specific objects and filter out or restrict the data exported. Step1: Source [...]
The SQL standard allows you to use an inline view in a DELETE statement, see the pseudo form below – If a condition such as key-preserved table is not met then it will result in error, “ORA-01752: cannot delete from view without exactly one key-preserved table.” I would like to show you the caveat of [...]
Software Performance and Scalability: A Quantitative Approach (Wiley, May 2009) is for people involved in designing, developing, testing, implementing and managing enterprise applications. This book provides the necessary quantitative foundation, analytical and measurement aspects of performance and scalability - effective blend of studies and practical examples, which makes it thorough, it easier to read and informative. [...]
Joins A join is a query that combines rows from two or more tables. Oracle performs a join whenever multiple tables appear in the FROM clause of the query. Below is a SQL join statement, legacy syntax and ANSI/ISO syntax (also referred as new join syntax, was first introduced in Oracle 9i release) in a [...]
Data quality is an important element in data management; it is a larger topic by itself. If you are looking for a book on data quality, don’t look further. Get a copy of Data Quality: The Accuracy Dimension (Morgan Kaufmann; 1st Edition, 2003). This book is about data accuracy, divided into three parts – Part [...]