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 10664sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 7558Suppose 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 8558Interchange 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 17924What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
ABC,
1 2269
What is sql server and ase?
What are % type and % rowtype?
Which sql statement is used to delete data from a database?
What is rename command in sql?
How does index help in query performance?
What is the use of partition by in sql?
What are the uses of merge?
What is the left table in sql?
What is the maximum number of triggers, you can apply on a single table?
What is the use of procedures?
What are stuff and replace function?
Which sql statement is used to return only different values?
What are pl sql data types?
What is recursive join in sql?
What is the current version of postgresql?