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 12159sales 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 10490Interchange 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 3068
What are the differences between implicit and explicit cursors?
What is dialect in sql?
how to use regular expression in pattern match conditions? : Sql dba
What is a pdo connection?
How can you get sql*loader to commit only at the end of the load file? : aql loader
what is subquery? : Sql dba
Where can I learn sql for free?
What is dml statement?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is cursor in pl sql?
what are numeric data types? : Sql dba
Is progress software supports to ( pl/sql )?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
what are myisam tables? : Sql dba
What is denormalization in a database?