Question

  1- Create table student5 as: 

 2- Write PL/SQL program using cursor to display student number and names who's their salary greater than 2500?

 3- Update the table students to increase the salary of each customer by 300?

Answer 1

1)

CREATE TABLE student5 (

St_no INT(5),

St_name VARCHAR(12),

Salary NUMBER,

Age INT(2),

Major VARCHAR(10)

);

3)

UPDATE student5 SET salary = salary + 300;

NOTE: As per Chegg policy I am allowed to answer specific number of questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.