In my previous articles i have given idea about the performance tuning techniques,Indexes in sql.In any performance tuning technique we require to create multiple indexes…
View More Gather stats in Oracle : Schema,Tables and IndexesCategory: SQL Tutorials
ORA-01157: cannot identify/lock data file string – see DBWR trace file
In my previous article i have given the idea about different errors coming in Oracle. In my last article i have given the idea about…
View More ORA-01157: cannot identify/lock data file string – see DBWR trace fileHow to UPDATE bulk of records in Oracle Database
In my previous article i have given the idea about how to update the records in sql. In this article i would like to give…
View More How to UPDATE bulk of records in Oracle DatabaseHow to calculate total size of the database
In my previous articles i have given the basic idea about the converting seconds in to time format and viceversa. In this article i would…
View More How to calculate total size of the databaseAlter statement to Add Constraints
In previous articles i have given the idea about the alter statements and its use in real world. In this article i would like to…
View More Alter statement to Add ConstraintsCopy Statement of PostgreSQL to import data from File
In previous article we have explained about the how to import the data from different file in oracle.In this article I would like to explain…
View More Copy Statement of PostgreSQL to import data from File10 Typical Mistakes in MySQL
Millions of people conduct their business via the Internet. They create websites to advertise and sell their products/services, find customers, suppliers, partners, etc. Every website,…
View More 10 Typical Mistakes in MySQLSQL Queries for Data Analysis | Data Analysis Queries
In my previous articles i have given the different SQL Queries examples- SQL for Testers, SQL for Business Analysts and so on. In this article…
View More SQL Queries for Data Analysis | Data Analysis QueriesOracle Autonomous Database |Oracle 19 c
In my previous articles i have already given the information about Oracle 18c with multiple real life examples. In this article i would like to…
View More Oracle Autonomous Database |Oracle 19 cSQL Contains String | SQL Contains String Examples
In my previous article i have given the details about different SQL statements with real life examples. There is always question in mind about the…
View More SQL Contains String | SQL Contains String Examples