Those who wanted to learn SQL or PL/SQL without installation oracle on Local PC, ORACLE provides “Oracle Application Express” where you can develop and deploy applications on web browser, there is no need to install anything. whether you are a beginner or a professional, Oracle APEX lets you develop web applications or learn sql or pl/sql.
Click “Request a Free Workspace” to register and get and the workspace. Then click “Get Started”
Enter First Name, Last name and the Email, click next.
Enter the workspace name, dont enter common names, try to enter unique names otherwise you may get error.
type the scheme name for the workspace and select the space required. click next. You will be asked for the reason for using this service, enter the details and click next.
Workspace creation completed. You will receive mail from oracle once the account is approved and workspace, username and password will be provided along with this.
Login using the credentials provided by oracle. In the Login screen, click SQL workshop to work on SQL or PL/SQL.
select “sql commands” under “sql workshop”
In the right corner of sql commands you can view object browser, click to select the demo tables and other objects details.
To execute any SQL or PL/SQL , goto sql commands.
Type the sql query & click “Run”, Using the demo tables available in db.
some of the queries tested in sql commands, you can join the queries, create your own tables, insert data into it & PL/SQL sample program.
SELECT * FROM demo_customers
SELECT * FROM demo_customers WHERE cust_state='VA'
SELECT * FROM demo_order_items doi, demo_orders dos WHERE doi.order_id=dos.order_id
CREATE TABLE mytable(name VARCHAR2(10), phone NUMBER(20))
INSERT INTO mytable VALUES ('lokesh','12345')
SELECT * FROM mytable
1 2 3 4 5 6 7 8
DECLARE a NUMBER:=10; b NUMBER:=20; c NUMBER; BEGIN c:=a+b; dbms_output.put_line(c); END