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 12164sales 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 10499Interchange 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 3073
Does oracle roll back the transaction on an error?
what are the difference between clustered and a non-clustered index? : Sql dba
What is a nested table in word?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is dense_rank in sql?
What is oracle and pl sql?
how to shutdown mysql server? : Sql dba
How do you run a query?
How to change sql*plus system settings?
What is record in pl sql?
How do you delete a table?
Can we create table inside stored procedure?
What does over partition by mean in sql?
Is pl sql a programming language?
Is left join same as join?