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 10632sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 7538Suppose 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 8513Interchange 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 17838What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
ABC,
1 2253
what are date and time intervals? : Sql dba
what are the non-standard sql commands supported by 'mysql'? : Sql dba
what is a relationship and what are they? : Sql dba
Why truncate is used in sql?
What is user in sql?
what are different types of keys in sql?
what are myisam tables? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
What are the types of join and explain each?
What is compiled query?
What are the sql commands?
How to load data with sql*loader?
What are the parameter modes supported by pl/sql?
How do you use join?
how does a local variable is defined using t-sql? : Transact sql