What are the type of joins? When do we use Outer and Self joins?

Answer Posted / shivanibehere

For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you insert null values in a column while inserting the data?

722


Explain the properties of sub-query in sql server?

515


What is a trigger? Why we need it?

535


Tell me the phases a transaction has to undergo?

554


What are dml triggers and types of dml triggers?

554






Can you leave a union at any time?

546


Tell me in brief how sql server enhances scalability of the database system?

537


Do you know the different ddl commands in sql?

593


Describe triggers features and limitations?

508


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

556


What is a trace frag? Where do we use it?

674


Where can you add custom error messages to sql server?

588


What is the filtered index?

564


Do you know what is xpath?

559


What is the sql server agent?

590