(Sateesh Kumar) Oracle is commonly using database as a backend for .NET applications. But, the main problem with oracle is, there is no in-built easy-to-use GUI for accessing objects in it. So the only option is to use third party tools like TOAD or PL/SQL Developer for accessing objects without wri
Tag: Oracle
Oracle’s Little-Known Multi-Table Insert
(Babette Turner-Underwood) We are assisting one of our clients with a data conversion project and have used a feature that I was surprised so few people knew about. It is the multi-table insert.
Connecting to Oracle or Access from ASP.NET 2.0
(Devin Rader and Bill Evjen) The SqlDataSource control is the data source control to use if your data is stored in a SQL Server, SQL Server Express, Oracle Server, ODBC data source, OLE DB data source, or Windows SQL CE Database. The control provides an easy-to-use wizard that walks you through the
Running Oracle WebForms like ‘a Client-server application’
(Bart) At our Oracle Competence we run a succesfull Designer/Developer migration solution in which we upgrade Forms from version 3.0-9i to 10g. Every now and then one of our customers raises the question if it’s possible to run Oracle Webforms in client-server mode “like they used to do”.
ADF Faces 10.1.3: Dynamic Menus w/ ADF Regions
(Olaf Heimburger) While developing my application I reused a number of pages for different pages flows for different user roles. This resulted in the need for different sub menus (aka “menu2” facet in ).
Adding Processes to HTML DB Applications
(Lawrence Linnemeyer and Bradley Brown) In this second part of a three-part series covering HTML DB applications, you will learn about processes.
EBS advanced topologies: Sharing APPL_TOP, ORACLE_HOMEs, err… heck, why don’t we share it all?
(Arnoud Roth) Implementing a shared APPL_TOP with E-Business Suite is common practice these days. Since 11.5.10, there is also support for a shared technology stack (8.0.6 and iAS ORACLE_HOMEs).
Build a Web Application with JDeveloper 10g Using EJB, JPA, and JavaServer Faces
In this tutorial, you use Oracle JDeveloper (10.1.3.1.0 or 10.1.3.2.0) to build a web application. EJB 3.0 and Java Persistence API (JPA) are used to build the data model. For the web client, JSF (JavaServer Faces) is used to build the user interface, which will include a master-detail page and an e
Quest Code Tester for Oracle
(Steve Callan) If you write any significant amount of PL/SQL code, your day of salvation has arrived, and the salvation is in the form of Quest Code Tester for Oracle (QCTO). If you work in a structured development environment (even minimally so), the responsibility for performing unit tests falls u
From Rows to Column
(Amit Zhankar) This script starts with rows and then returns results in one column.
