what is self join and why is it required? : Sql dba
Answer / suresh pagadala
Self join is nothing but the table performs join condition itself same table is called self join
Is This Answer Correct ? | 0 Yes | 0 No |
What are types of exception?
what are the drivers in mysql? : Sql dba
Give the structure of the function ?
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
what is the difference between trigger and storedprocedures
How can a pl sql block be executed?
What are the blocks in stored procedure?
what is 'mysqld'? : Sql dba
How can we schedule the procedure to run automatically ?
Is sql better than excel?
What is duration in sql profiler trace?
Why do we create views in sql?