Run Sql*Plus commands on Application Express
Posted
by pesantos
on Stack Overflow
See other posts from Stack Overflow
or by pesantos
Published on 2010-04-23T18:24:17Z
Indexed on
2010/04/23
18:33 UTC
Read the original article
Hit count: 243
Hi, I am new to PL/SQL, I'm trying to execute the commands that I learned at the course.
VARIABLE area NUMBER
DECLARE
radius NUMBER(2) := &s_radius;
pi CONSTANT NUMBER := 3.14;
BEGIN
:area := pi * radius * radius;
END;
I understand that I can run this using SqlPlus, but I remember my teacher was running this from the web browser using Application Express. I try to run the same commands there, at HOME >SQL>SQL Commands, but I keep getting the error
"ORA-00900: invalid SQL statement"
.
Can you help me run it in Application Express or point me to a way where I can use an editor to run these course exercises?
Thanks!
© Stack Overflow or respective owner