question 1 create a table student with attributes

Question

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations

1. Insert details in to the table
2. Update the details of the student named ‘JOHN'
3. Delete details of the student ‘Mary'
4. Display the details of students having more than 80%

 

Question 2 Write the following Queries using functions

1. Write a query to display the sub string for the word 'oracle' from its position 2 to 3
2. Write a query to change the ‘or' to ‘ab' in the word 'corporation' using translate function
3. Write a query to maintain the first letter as caps using initcap function
4. Write a query to display all characters is in caps using upper function
5. Write a query to display ‘smudde' after leaving 5 blank places using lpad function