1. Retrieve and print the data of an
employee having name=’Rishi' using Record.2. Retrieve and print the data of all
the employees using Explicit Cursors.3. Write a PL/SQL code block to
display the names and GPA of students from student table...
Thursday, December 3, 2020
My life experince say that Wake up and run for your work bacause Life is incomplete without work.The work is not big, only its lazy is bigger, which says that don't do it but if we want to do something big in life, we have to lose everything and run towards our goal.
Tuesday, December 1, 2020
undefined
202
1. Write a PL/SQL code block for
calculating addition of Three numbers.2. Write a PL/SQL code block to find
out larger between two numbers.
3. Write a PL/SQL code block to find
largerst of three numbers.
4. ...
My life experince say that Wake up and run for your work bacause Life is incomplete without work.The work is not big, only its lazy is bigger, which says that don't do it but if we want to do something big in life, we have to lose everything and run towards our goal.
Thursday, November 19, 2020
undefined
202
Q1. Create a new column DoB in Student table. (Datatype will be date) Q2. Insert DoB for each Student in corresponding table using above instance of Student
table. Q3. Find average of GPA round off to 2 decimal places. Q4. Find year of DoB of Student having less than 1000. Q5. Compute Age of each...
My life experince say that Wake up and run for your work bacause Life is incomplete without work.The work is not big, only its lazy is bigger, which says that don't do it but if we want to do something big in life, we have to lose everything and run towards our goal.
Monday, November 16, 2020
undefined
202
1: Which of the following statement is true in case of “dropping a table”? A: Table structure and data is deleted C: Drops the indexes B: Invalidates the dependent objects D: All the above 2: There are two relations GATE_2014(exam_date, exam_center, branch_id) and Candidate (rollno, name, bid, refno, choice_of_date)....
My life experince say that Wake up and run for your work bacause Life is incomplete without work.The work is not big, only its lazy is bigger, which says that don't do it but if we want to do something big in life, we have to lose everything and run towards our goal.
Posts
