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 12145sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 8335Suppose 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 10477Interchange 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 19893What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
ABC,
1 3056
What is the current version of postgresql?
what is the difference between undefined value and null value? : Sql dba
What is sql*plus?
Are dml statements autocommit?
what happens if you no create privilege in a database? : Sql dba
Difference between truncate, delete and drop commands?
What is sqlerrd?
how to select first 5 records from a table? : Sql dba
What does sign mean sql?
What is procedure explain with example?
What are the types pl/sql code blocks?
What is dynamic sql in pl sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How do I run sql profiler?
What are sql ddl commands?