Interested to Buy Any Domain ? << Click Here >> for more details...
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..
2498If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
2 6930one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
TCS,
9 11075one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
13 23709
What is compound trigger?
Why stored procedure is better than query?
What is difference between sql function and stored procedure?
what is view? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Why is sharding used?
How is data stored in sql?
What is primary and foreign key?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Does sql backup shrink transaction log?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are the query optimization techniques?
What is the difference between mdf and ndf files?
Does inner join return duplicate rows?
