using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
4 12160sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 8338Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
IBM,
6 10492Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
4 19909What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
ABC,
1 3069
Does sql*plus have a pl/sql engine?
how to rename an existing table in mysql? : Sql dba
What is example of database?
Name the different types of indexes in sql and define them.
What is the difference between subquery and correlated query?
How many types of primary keys are there?
Advantages and disadvantages of stored procedure?
Explain autonomous transaction.
What is the purpose of a secondary key?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
what is the difference between clustered and non clustered index in sql? : Sql dba
Define sql delete statement.
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Is pl sql better than sql?
what is clause? : Sql dba