Please name some online websites to compile and run PL SQL

0 votes
I want to execute programs of PL/SQL online, can anybody suggest any website which can compile and run the code and give me the result?
Feb 11 in Database by Vaani
• 5,240 points
52 views

1 answer to this question.

0 votes
For executing Oracle SQL queries and PL/SQL Code, you can refer to the websites below:

Oracle Live Sql -  you can save all your PL/SQL scripts

Sql Fiddle - you can create schemas and queries and share them with other users.

Oracle Apex -you can test out Apex, which can let you create objects and run scripts.

Sql Zoo - It is a  PL/SQL coding ground to create objects and run scripts

Tutorials Point-  Here also you can create objects and run scripts

You can execute .sql scripts by using the following steps.

1.Click on new project.

2.Click on '+' symbol. -- A new .sql file will be created (Newfile.sql)

3.Execute the .sql as @filename.sql (Ex : @Newfile.sql )
answered Feb 11 by Neha
• 6,260 points

Related Questions In Database

+1 vote
3 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

answered Sep 25, 2019 in Database by gautham
686 views
0 votes
1 answer

How to schedule a job for SQL query to run daily?

down voteaccepted Expand the SQL Server Agent node ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
7,661 views
0 votes
1 answer

How to schedule a job for sql query to run daily?

Hii, To schedule a job for sql query ...READ MORE

answered May 4, 2020 in Database by Niroj
• 82,680 points
735 views
0 votes
1 answer

What is the difference between SQL, PL-SQL and T-SQL?

SQL SQL is the standard language for relational ...READ MORE

answered Feb 16 in Database by Vaani
• 5,240 points
65 views
0 votes
1 answer

Number of rows affected by an UPDATE in PL/SQL

You can try using the following query: SELECT ...READ MORE

answered Feb 14 in Database by Vaani
• 5,240 points
57 views
0 votes
1 answer

SQL error "ORA-01722: invalid number"

When an effort is made to convert ...READ MORE

answered Feb 15 in Database by Neha
• 6,260 points
229 views
0 votes
1 answer

Automating Oracle script with nolio

Depending upon the details of your script ...READ MORE

answered Jul 17, 2018 in Other DevOps Questions by ajs3033
• 7,280 points
313 views
0 votes
1 answer

Is there any boolean type in Oracle database?

Nope. I don't think there is one But ...READ MORE

answered Oct 10, 2018 in Database by Neha
• 6,300 points
274 views
0 votes
1 answer

How to drop all tables from a database with one SQL query?

Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE

answered Feb 4 in Database by Neha
• 6,260 points
101 views
0 votes
1 answer

How to rename a column in a database table using SQL?

For SQL Server, use sp_rename USE AdventureWorks; GO EXEC sp_rename 'Customers.CustomerTerritory.TerritoryID', ...READ MORE

answered Feb 9 in Database by Neha
• 6,260 points
54 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP