¿Cómo ejecuto una consulta SQL en Oracle?

How do I run a SQL query in Oracle?

To run queries in SQL Developer:

1. Click the icon SQL Worksheet.
2. If the Select Connection window opens:
3. In the SQL Worksheet pane, type a query (a SELECT statement).
4. Click the icon Execute Statement.
5. Click the tab Results.
6. Click the icon Clear.

This leaves you free to roll up your sleeves and get your hands dirty with plenty of practice problems and successful SQL statements.

• SQL Fiddle. SQL Fiddle is a great place to start if you’re looking to, well, fiddle around with SQL.
• SQLZOO.
• Oracle LiveSQL.
• W3resource.
• Stack Overflow.
• DB-Fiddle.
• GitHub.
• Coding Ground.

Text Editor

1. Type your code in a text editor, like Notepad, Notepad+, or EditPlus, etc.
2. Save the file with the . sql extension in the home directory.
3. Launch the SQL*Plus command prompt from the directory where you created your PL/SQL file.
4. Type @file_name at the SQL*Plus command prompt to execute your program.

Within 15 min, I was online with a seasoned engineer who was editing my code and pointing out my errors … this was the first time I’ve ever experienced the potential of the Internet to transform learning. I will help you learn and build up your own coding style and mindset.

Not only knows his stuff but also is able to teach you what he is doing so you improve as a coder. Highly recommend ” “ As usual, he was able to identify the problem and resolve it. He also explained the solution to me.

Microsoft Certified Professional having 16 years of software development experience within Microsoft technology skills such as C#.Net, VB.Net & SQL Server, and Cloud computing – Mi…