how are rank and dense rank being alloted for column with same values over a particular column
1 2485Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
1300
What are analytical functions in sql?
How do you use collections in procedure to return the resultset?
Does varchar need length?
What is the difference between truncate and drop statements?
What is constant in pl sql?
Sql technical questions
What is synchronized subquery?
What is sql query optimization?
What is primary key and foreign key?
define join and explain different type of joins? : Sql dba
explain normalization concept? : Sql dba
How many times can we commit in a loop?
Is sql a backend?
How does pl sql work?
Why is stored procedure faster than query?