SQL> CREATE TABLE product (
num INT, name VARCHAR2(20),
price INT, year INT);
==========================
Insert records:
INSERT INTO product VALUES (1, 'mouse', 15, 2020);
INSERT INTO product VALUES (2, 'keyboard', 30, 2021);
INSERT INTO product VALUES (3, 'monitor', 200, 2019);
INSERT INTO product VALUES (4, 'speakers', 50, 2022);
INSERT INTO product VALUES (5, 'printer', 100, 2018);
INSERT INTO product VALUES (6, 'mouse', 12, 2021);
INSERT INTO product VALUES (7, 'keyboard', 35, 2020);
INSERT INTO product VALUES (8, 'monitor', 180, 2023);
INSERT INTO product VALUES (9, 'speakers', 45, 2017);
INSERT INTO product VALUES (10, 'printer', 110, 2019);
INSERT INTO product VALUES (11, 'mouse', 14, 2022);
INSERT INTO product VALUES (12, 'keyboard', 28, 2018);
INSERT INTO product VALUES (13, 'monitor', 220, 2021);
INSERT INTO product VALUES (14, 'speakers', 55, 2020);
INSERT INTO product VALUES (15, 'printer', 105, 2016);
INSERT INTO product VALUES (16, 'mouse', 18, 2019);
INSERT INTO product VALUES (17, 'keyboard', 32, 2023);
INSERT INTO product VALUES (18, 'monitor', 190, 2015);
INSERT INTO product VALUES (19, 'speakers', 60, 2022);
INSERT INTO product VALUES (20, 'printer', 95, 2020);
num INT, name VARCHAR2(20),
price INT, year INT);
==========================
Insert records:
INSERT INTO product VALUES (1, 'mouse', 15, 2020);
INSERT INTO product VALUES (2, 'keyboard', 30, 2021);
INSERT INTO product VALUES (3, 'monitor', 200, 2019);
INSERT INTO product VALUES (4, 'speakers', 50, 2022);
INSERT INTO product VALUES (5, 'printer', 100, 2018);
INSERT INTO product VALUES (6, 'mouse', 12, 2021);
INSERT INTO product VALUES (7, 'keyboard', 35, 2020);
INSERT INTO product VALUES (8, 'monitor', 180, 2023);
INSERT INTO product VALUES (9, 'speakers', 45, 2017);
INSERT INTO product VALUES (10, 'printer', 110, 2019);
INSERT INTO product VALUES (11, 'mouse', 14, 2022);
INSERT INTO product VALUES (12, 'keyboard', 28, 2018);
INSERT INTO product VALUES (13, 'monitor', 220, 2021);
INSERT INTO product VALUES (14, 'speakers', 55, 2020);
INSERT INTO product VALUES (15, 'printer', 105, 2016);
INSERT INTO product VALUES (16, 'mouse', 18, 2019);
INSERT INTO product VALUES (17, 'keyboard', 32, 2023);
INSERT INTO product VALUES (18, 'monitor', 190, 2015);
INSERT INTO product VALUES (19, 'speakers', 60, 2022);
INSERT INTO product VALUES (20, 'printer', 95, 2020);
👍1
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8'>
<meta http-equiv='X-UA-Compatible' content='IE=edge'>
<title>Login Page</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' type='text/css' media='screen' href='main.css'>
<script src='main.js'></script>
</head>
<body>
<fieldset>
<table border="0">
<h2>Login Form</h2>
<form action="Login.jsp">
<tr>
<td> User Name:</td>
<td> <input type="text" name="uname" placeholder="Enter Your Name"></td>
</tr>
<tr>
<td> Password:</td>
<td><input type="password" name="psw" placeholder="Enter Your Password"></td>
</tr>
<tr>
<td></td>
<td> <input type="submit" value="Login"></td>
</tr>
</form>
</table>
</fieldset>
</body>
</html>
<html>
<head>
<meta charset='utf-8'>
<meta http-equiv='X-UA-Compatible' content='IE=edge'>
<title>Login Page</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' type='text/css' media='screen' href='main.css'>
<script src='main.js'></script>
</head>
<body>
<fieldset>
<table border="0">
<h2>Login Form</h2>
<form action="Login.jsp">
<tr>
<td> User Name:</td>
<td> <input type="text" name="uname" placeholder="Enter Your Name"></td>
</tr>
<tr>
<td> Password:</td>
<td><input type="password" name="psw" placeholder="Enter Your Password"></td>
</tr>
<tr>
<td></td>
<td> <input type="submit" value="Login"></td>
</tr>
</form>
</table>
</fieldset>
</body>
</html>
👍1🥰1
Forwarded from ORACLE BATCH 2024
Create table with name Student:
=================================
SQL> create table student(sid number(20), sname varchar2(20), age number(20),
course varchar2(20), fees number(30), location varchar2(20));
Insert records into Student table:
=================================
insert into student values(101, 'ram', 24, 'java', 12000, 'hyderabad');
insert into student values(102, 'amar', 27, 'c', 5000, 'pune');
insert into student values(103, 'satya', 21, 'python', 9000, 'chennai');
insert into student values(104,'pavan',28,'android',8000, 'hyderabad');
insert into student values(105, 'harin', 22, 'java', 12000, 'bangalore');
insert into student values(106, 'swathi', 19, 'android', 8000, 'chennai');
insert into student values(107, 'raji', 20, 'c', 5000, 'pune');
insert into student values(108, 'jaya', 25, 'java', 12000, 'hyderabad');
insert into student values(109, 'harsha', 29, 'python', 9000, 'chennai');
insert into student values(110, 'vijaya', 20, 'java', 12000, 'hyderabad');
=================================
SQL> create table student(sid number(20), sname varchar2(20), age number(20),
course varchar2(20), fees number(30), location varchar2(20));
Insert records into Student table:
=================================
insert into student values(101, 'ram', 24, 'java', 12000, 'hyderabad');
insert into student values(102, 'amar', 27, 'c', 5000, 'pune');
insert into student values(103, 'satya', 21, 'python', 9000, 'chennai');
insert into student values(104,'pavan',28,'android',8000, 'hyderabad');
insert into student values(105, 'harin', 22, 'java', 12000, 'bangalore');
insert into student values(106, 'swathi', 19, 'android', 8000, 'chennai');
insert into student values(107, 'raji', 20, 'c', 5000, 'pune');
insert into student values(108, 'jaya', 25, 'java', 12000, 'hyderabad');
insert into student values(109, 'harsha', 29, 'python', 9000, 'chennai');
insert into student values(110, 'vijaya', 20, 'java', 12000, 'hyderabad');
👍3