Retrieve data using Procedure in Oracle

Step-1:  Create table CREATE TABLE student ( USER_ID NUMBER (5) NOT NULL, USERNAME VARCHAR2 (20) NOT NULL, PRIMARY KEY ( USER_ID ) ) Step-2: Create Procedure CREATE OR REPLACE PROCEDURE getStudentByUserId( p_userid IN STUDENT.USER_ID%TYPE, p_username OUT STUDENT.USERNAME%TYPE) IS BEGIN SELECT USERNAME INTO p_username from STUDENT...

Oracle Database: Lecture – 01

Question: What is data? Answer: Every organization has some information needs. A library keeps a list of members, books, due dates, and fines. A company needs to save information about employees, departments, and salaries. These pieces of information are called data.