Question 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%.
Question 2:
Write the following Queries by using functions.
a) Write query to exhibit the sub string for the word ‘oracle’ from its position 2 to 3.
b) Write query to change the ‘or’ to ‘ab’ in the word ‘corporation’ using translate function.
c) Write query to sustain the first letter as caps using initcap function
d) Write query to show all characters is in caps using upper function
e) Write query to exhibit ‘smudde’ after leaving 5 blank places using lpad function.