| CARVIEW |
Select Language
HTTP/2 200
date: Sat, 11 Oct 2025 21:17:39 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=761a828806598c896c501158251157d2fb41a7108c04e958f1b1844a76530aa4a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22iuYIwzxBehm4X0iixNhDL-zbh3XqrQye%22%3B%7D; HttpOnly; Path=/
cf-ray: 98d162b1dc0695be-BLR
lab assignment(07/11/23) - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE employee_29(
- emp_no NUMBER(10) PRIMARY KEY,
- ename VARCHAR2(30),
- dept_no NUMBER(3),
- contact NUMBER(10) CONSTRAINT uc_contact UNIQUE,
- address VARCHAR2(200)
- );
- INSERT ALL
- INTO employee_29 (emp_no, ename, dept_no, contact, address) VALUES (1000001, 'Rajesh', 101, 9876543210, '123, ABC Street')
- INTO employee_29 (emp_no, ename, dept_no, contact, address) VALUES (2000002, 'Suresh', 102, 8765432109, '456, XYZ Street')
- INTO employee_29 (emp_no, ename, dept_no, contact, address) VALUES (3000003, 'Amit', 103, 7654321098, '789, PQR Street')
- INTO employee_29 (emp_no, ename, dept_no, contact, address) VALUES (4000005, 'Priya', 104, 6543210987, '321, LMN Street')
- INTO employee_29 (emp_no, ename, dept_no, contact, address) VALUES (5000006, 'Anita', 105, 5432109876, '654, EFG Street')
- SELECT * FROM dual;
- SELECT * FROM EMPLOYEE_29;
- SELECT Ename,Contact FROM employee_29;
- SELECT dept_no, COUNT(*) AS num_employees
- FROM employee_29
- GROUP BY dept_no;
- SELECT AVG(LENGTH(contact)) AS avg_contact_length
- FROM employee_29;
- SELECT *
- FROM employee_29
- ORDER BY dept_no, ename;
- SELECT *
- FROM employee_29
- WHERE ename LIKE '%A%';
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐⭐⭐MAKE $9OO INSTANTLY D M⭐⭐
Java | 1 sec ago | 0.10 KB
-
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ 7
JavaScript | 10 sec ago | 0.25 KB
-
⭐⭐⭐Swapzone.io Glitch (Working)⭐⭐
Java | 12 sec ago | 0.10 KB
-
📝 EASY MONEY GUIDE ✅ Working
JavaScript | 15 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ 1
JavaScript | 19 sec ago | 0.25 KB
-
📌 ChangeNOW Exploit
JavaScript | 24 sec ago | 0.24 KB
-
⭐✅ Swapzone Glitch ✅ Working ⭐⭐ E
JavaScript | 28 sec ago | 0.25 KB
-
✅ Make $2500 in 20 minutes⭐⭐⭐ X
JavaScript | 37 sec ago | 0.25 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
