Write a program to enter two numbers and find their sum in PLSQL block .
Practical Practice 2 Oracle Practice Write a program to enter two numbers and find their sum in PLSQL block . Write a program to enter two numbers and find their sum in PLSQL block . SOLUTION –Static code set serveroutput on; DECLARE number1 number := 10; number2 number := 20; tot number; BEGIN tot := […]
Write a code to print “Hello World” in PLSQL block.
Practical Practice 1 Oracle Practice Write a code to print “Hello World” in PLSQL block. Write a program to print “Hello World” in PLSQL block. SOLUTION –Static code set serveroutput on; DECLARE mes varchar2(100) := ‘Hello World’; BEGIN dbms_output.put_line(mes); END; / –Dynamic code set serveroutput on; DECLARE mes varchar2(100) := ‘&mes’; BEGIN dbms_output.put_line(mes); END; / […]
Practical Practice for Oracle – 2
Practical Practice -2 Oracle Practice Overview Practice -2 SOLUTION create table infant ( item_code number primary key, item varchar2(100) not null, DatePurchase date, UnitPrice number, Discount number); SOLUTION insert into infant values(101,’Frock’,’23-Jan-2016′,700,10); insert into infant values(102,’Cot’,’23-Sep-2015′,5000,25); insert into infant values(103,’Soft Toy’,’17-Jun-2016′,800,10); insert into infant values(104,’Baby Socks’,’16-Oct-2014′,100,7); insert into infant values(105,’Baby Suit’,’20-Sep-2015′,500,5); SOLUTION 1 SELECT […]
Create a table Infant and Solve the following queries………..
CLASS 12th IP Practical-3 Class 12th IP SOLUTION -> create database exam; -> use exam; -> create table infant ( item_code int primary key, item varchar(100) not null, DatePurchase date, UnitPrice int, Discount int); -> Insert query insert into infant values(101,’Frock’,’2016-01-23′,700,10); insert into infant values(102,’Cot’,’2015-09-23′,5000,25); insert into infant values(103,’Soft Toy’,’2016-06-17′,800,10); insert into infant values(104,’Baby Socks’,’2014-10-16′,100,7); […]
Write a Program to create a Pandas Matplotlib
CLASS 12th IP Practical-2 Class 12th IP SOLUTION import matplotlib.pyplot as plt import numpy as np # DATA student = [‘Mohit’,’Nishant’,’Sudha’] subjects = [‘Maths’,’Science’,’English’] marks = [ [100,100,60], [95,100,57], [85,95,96]] x = np.arange(len(subjects)) #[0,1,2] # Bar width bar_width = 0.25 # Creating a bar Chart plt.bar(x – bar_width,marks[0],width = bar_width , label=’Mohit’,color=’green’) plt.bar(x, marks[1] , […]
Question_Bank
Q.1 Write a program to Create a Series from Scalar Values. Q.2 Write a Program to Creation of Series from NumPy Arrays. Q.3 Write a program to Creation of Series from Dictionary Q4 Write a Program to Accessing Elements of a Series. Q.5 Write a program to create a series object using the […]
Create a DataFrame and Solve the following Queries in Python Pandas
CLASS 12th IP Practical-1 Class 12th IP SOLUTION import pandas as pd a = {‘Maths’:[100,95,85], ‘SCIENCE’:[90,50,90], ‘ENGLISH’:[85,90,65] } df = pd.DataFrame(a,index=[‘Mohit’,’Nishant’,’Sudha’]) print(df) print(“———————–1———————-“) print() df[‘total’]=df[‘Maths’] + df[‘SCIENCE’] + df[‘ENGLISH’] print(df) print(“——————-2——————–“) print() df.loc[‘Harish’]=[77,85,69,77+85+69] print(df) print(“————————3———————“) print() print(df[[‘Maths’,’SCIENCE’]]) print(“——————4——————-“) print() df.loc[‘Sudha’,’SCIENCE’]=85 print(df) print(“———————-5—————–“) print() df = df.drop(index=’Mohit’) print(df) Output
Unit 3 :- PL/SQL and conditional Statements
PL/sQL and conditional statement INDEX 3.1 Introduction to PL/SQL (Definition & Block Structure) 3.2 Variables, Constants and Data Type 3.3 Assigning Values to Variables 3.4 User Defined Record 3.5 Conditional Statements 3.5.1 IF…THEN statement 3.5.2 IF..Else statements 3.5.3 multiple conditions 3.5.4 Nested IF statements 3.5.5 CASE statements PL/sQL and conditional statement Introduction to PL/SQL PL/SQL […]
Unit-2 Advanced SQL
Unit-2 Advanced SQL SQL : A Brief Overview SQL (Structured Query Language) is a standard programming language used to interact with relational databases. It enables users to perform operations like creating, retrieving, updating, and managing data stored in database tables. SQL is essential for database management and widely used in software development, data analysis, and […]
Unit-1. Introduction of Relational model
Unit-1. Introduction of Relational model Introduction to the Relational Model The relational model is a fundamental concept in database management systems (DBMS). Introduced by Edgar F. Codd in 1970, the relational model organizes data into tables, called relations, making it easier to understand, query, and manage information. Key Concepts of the Relational Model 1. Relation […]