1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
1 6883create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
2 7584How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 16368What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 4038Post New Polaris SQL PLSQL Interview Questions
What are subqueries in sql server?
What is the total generic pointer type?
What is sequence classification?
What do shuffling do?
What is the use of datastage director?
What does b mean in code?
How do you select a table?
What is routing in laravel?
Do you know spatial data types - geometry and geography in sql server 2008?
There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.
What is difference between php and wordpress?
Can a class extend itself?
What is mean carry over of Aux. Boiler?
What are the differences between different versions of co-op?
Can a loop recorder detect a heart attack?