Home » SQL & PL/SQL » Client Tools » Interface screen for Oracle database (oracle10g)
Interface screen for Oracle database [message #440242] Thu, 21 January 2010 15:10 Go to next message
shrinika
Messages: 252
Registered: April 2008
Senior Member
We are using oracle10g database. Customers calls ops team and ask about their security questions.
Every time, we need to run the sql query and find answers for them. We are getting lot of request
every day. I wanted to develop interface and i want ops team use the interface to pull the data.

Here are my thoughts...

1. using oracle APEX to develop interface.

2. Use the excel to write macro and get the answers for user request.

3. I can write a PLSQL to run the batch job and extract the data into excel and give it to ops team.


Please share if you have any other options...
Re: Interface screen for Oracle database [message #440279 is a reply to message #440242] Fri, 22 January 2010 00:03 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using SQL script in SQL*Plus.

Regards
Michel
Previous Topic: login.sql not working?
Next Topic: Problems with Substitute Variable Prompts
Goto Forum:
  


Current Time: Fri Sep 30 22:45:24 CDT 2016

Total time taken to generate the page: 0.10533 seconds