Learn SQL using Oracle Database

Learn SQL using Oracle Database | Part-1 Of 10

Within A Day, learn SQL using Oracle Database. Retrieving Data Using the SQL SELECT statement Capabilities of SQL SELECT Statement A SELECT statement retrieves information from a database table. With a SELECT statement, you can do the following: Projection Select the column in a table...

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.