In previous article i have given the basic idea about how to create a table in SQL. In this article i would like to give…
View More How to create duplicate table in SQL? | Creating duplicate tableCategory: SQL Tutorials
How to remove oracle table lock?
In my previous articles i have given so many real life SQL scenarios in which are useful. In this article i would like to give…
View More How to remove oracle table lock?How to find out the table was last modified in Oracle?
In my previous article i have given idea about the how to find out backup of table? and questions like that. In this article i…
View More How to find out the table was last modified in Oracle?How to connect Oracle without tnsnames.ora
There is always a question in mind that how to connect to the oracle?I already given information about Oracle database management system in my previous…
View More How to connect Oracle without tnsnames.oraHow to check Oracle client is 32 bit or 64 bit?
In my previous articles i have given the detailed level idea about the multiple types of errors in oracle.I would like to give you detailed…
View More How to check Oracle client is 32 bit or 64 bit?Gather stats in Oracle : Schema,Tables and Indexes
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 IndexesORA-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 | How to add constraints in SQL?
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 Constraints | How to add constraints in SQL?