Any online website to execute pl sql programs

sql plsql oracle11g saas
Learner picture Learner · Jul 23, 2012 · Viewed 77.6k times · Source

I want to execute programs of PL/SQL on-line. Can any one suggest me website to do it?

Answer

Burhan Ali picture Burhan Ali · Aug 1, 2012

SQL Fiddle

Here is a trivial example of use:

http://sqlfiddle.com/#!4/8cf15/5

Related questions

Using bind variables with dynamic SELECT INTO clause in PL/SQL

I have a question regarding where bind variables can be used in a dynamic SQL statement in PL/SQL. For example, I know that this is valid: CREATE OR REPLACE FUNCTION get_num_of_employees (p_loc VARCHAR2, p_job …

Read More
Sleep function in ORACLE

I need execute an SQL query in ORACLE it takes a certain amount of time. So I wrote this function: CREATE OR REPLACE FUNCTION MYSCHEMA.TEST_SLEEP ( TIME_ IN NUMBER ) RETURN INTEGER IS BEGIN DBMS_LOCK.sleep(seconds => TIME_); …

Read More
PLS-00428: an INTO clause is expected in this SELECT statement

I am wanting to store a Rownum as a variable rather than use a costly Join. I need to get this from a Select statement as the Rownum will be different on various environments so it cannot be a literal …

Read More