-
Find Base Table of the View
Views are created on the basis of base tablesWhat is the query to know the base table of the view? How to know the details of base table?
-
Birthdate Query
There is a table friends having following detailsName BirthdayJohn 28-jun-1985Peter 27-aug-1987Tom 13-aug-1986Nick 29-apr-1987Natalia 25-apr-1984Kate 28-jun-1984Wilson 11-nov-1987krish 31-jul-1987robert 25-apr-1984 SELECT names of the friends which come on the same day.. condition you don't know which birthday's repeat SELECT distinct...
-
Cursor Advantages and Disadvantages
What are the uses of Cursor? What are its advantage and disadvantage?
-
-