Oracle Database / Applications Topics:
Oracle development languages
This topic provides Oracle programmers/coders/developers news, tips and advice on the various development languages used with Oracle databases and Oracle applications, including SQL, PL/SQL, stored procedures, Java and J2EE, and XML, SOA and Web services.
Highlights
-
Columns in the SELECT not in the GROUP BY Ask the Expert - I have an SQL query where I am using the SUM function with the GROUP BY clause. I need to select a couple more columns from the table without adding those columns in the GROUP BY clause.
- PL/SQL do's and don't's: Five questions with Steven Feuerstein Tip - Oracle PL/SQL expert Steven Feuerstein advises on what you should never do in PL/SQL -- and what you should always do.
- Oracle SQL Developer vs. Toad: Users speak out, part two Article - Oracle developers are still talking about their favorite PL/SQL editing and debugging tools, and their opinions aren't confined to just Toad and SQL Develper.
- Oracle vs. SAP: The SOA factor Article - SAP is beating Oracle on the SOA front, but IBM has got the edge over them both, says one expert. But who's in front may not matter for many just yet. Plus, SOA planning tips.
BPEL in Oracle
Find BPEL tutorials and learn about Oracle in BPEL, including the Oracle BPEL process manager, BPEL tools and open source BPEL.SQL
Browse hundreds of tips, tutorials and expert responses on SQL (structured query language), the most popular development language for database management systems like Oracle.PL/SQL
Browse our compendium of tips, expert advice and analysis on PL/SQL, Oracle's proprietary procedural extension of the structured query language (SQL) for Database 7, 8i, 9i, 10g and 11g.Stored procedures
Learn more about using stored procedures, subroutines available to applications accessing the database, in Oracle. Browse our large collection of tips, tutorials, scripts and expert answers to technical questions.Java / J2EE
Oracle's JDeveloper, TopLink and related J2EE development tools make it a leader in Java development for the enterprise. Browse technical tips, script and expert advice about using Java and J2EE for Oracle application development in this section.XML
Browse all our tips and expert advice related to Oracle XML and related terms and technologies.
Oracle White Papers: Fusion Middleware