How many types of functions are there in sql?
No Answer is Posted For this Question
Be the First to Post Answer
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
How do you optimize a stored procedure query?
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,
what is the stuff function and how does it differ from the replace function? : Sql dba
When do we create bitmap indexes
What is the difference between delete and truncate statement in sql?
what are the different index configurations a table can have? : Sql dba
What is a database event trigger?
How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra
What is scalar function in sql?
What does seeding a database mean?