problem 1:

Make a table student with attributes student roll number, name, total marks and percentage. Do the following operations:

1) Insert details in the table

2) Upgrade the details of student named ‘JOHN’

3) Delete details of student ‘Mary’

4) Show the details of students having more than 80%.

problem 2:

prepare the following Queries by using functions.

a) prepare query to exhibit the sub string for the word ‘oracle’ from its position 2 to 3.

b) prepare query to change the ‘or’ to ‘ab’ in the word ‘corporation’ using translate function.

c) prepare query to sustain the first letter as caps using initcap function

d) prepare query to show all characters is in caps using upper function

e) prepare query to exhibit ‘smudde’ after leaving 5 blank places using lpad function.