What are primary key and foreign key and how they work?
what is Difference between Having and Where clause?
What is faster join or subquery?
What are the types of SQL Statement?
What is join view in sql?
if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is TABLE SPACE?
what are string data types? : Sql dba
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
What is mutating table?
which operator is used in query for pattern matching? : Sql dba