SQL & PL/SQL :: Customized Query Builder Architecture

Feb 5, 2013

I got a task to send some alters based on the user query data .As user is not a SQL expert, so we have to provide him a query builder. Now to store user query, I decided to build a data model and keeping in mind the reusability of previously made queries (so that we can use them directly in further queries).Like a user made two queries:

1. Find patient id, name, sugar_level, pulse_rate, weight for those patients whose diabitic level is greater than 'X'
2. Find patient id, pulse_rate for all those patients whose diabitic level is greater than 'X' and weight > 90

So first query can be directly used in second query. (Just a very simple example)But I am pretty much confused with the decision of columns for each table to store query and how to relate them.

Tables I am able to identify is :

1. Table to store query level details, i.e. query_id, who created, query_short_name, query_description, operator used (SET, GROUP BY, HAVING, etc), distinct indicator, etc.
2. select clause table or columns selected table
3. From clause table
4. table to store group by clause
5. table to store having clause

I am trying to store seprate parts of the query into seprate tables, but not getting which columns to have in each table, how to relate them... and after that, for a given query_id, procedure to construct a whole query, and then validate/parse and execute it using dbms_sql and scheduler.

View 6 Replies


ADVERTISEMENT

Application Express :: Query Builder Show Nothing?

Sep 16, 2013

i am trying to use the query builder in my 11g xe database but vainly ,there are no results shown ? 

View 6 Replies View Related

Reports & Discoverer :: Use Graphic Builder To Make Chart In Report Builder?

Aug 10, 2010

i want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf

View 6 Replies View Related

Data Guard :: Standby Database Architecture

Jul 8, 2011

To have physical standby database, the hardware and software versions should be same, including patch sets?

View 3 Replies View Related

Server Administration :: Database File System Architecture For Data Warehouseing Application

Mar 14, 2011

Which is the best possible way of configuring the Physical file structure in case of Data Warehouseing application?

I mean to ask you Multiplexing of the data file or control file is required. Or any best possible way to configure Physical file structure.

View 1 Replies View Related

Reports & Discoverer :: Customized System On Oracle 10g

Jun 30, 2011

I have customized system on oracle 10g ( English interface and reports ) , the company want to make the system in both (Arabic and English) , i make every thing is okay , but the problem when i change the PDF subset in the file uifont.ali to include Arabic fonts , the report server every 2 hours stopped and give me the message ( server is in progress ) ,

View 1 Replies View Related

Distinguish Between Oracle Predefined Users / Roles - Customized Ones?

Apr 18, 2012

I am looking for a query which can select all existing Oracle predefined users and roles from db.I need it because one of my other scripts needs to know a given user name or role is a customised one or a system one.It looks like sys.user$ does not have any column that can be used to distinguish predefined users/roles.

I could find all the list of Oracle predefined users and roles by googling and hardcoded them in a query. I can also collect all the customised users and roles as well. However, I prefer a query which can automatically reports that and minimise the maintenance cost as new names and roles, either Oracle predefined or customised, may come out at anytime.

View 6 Replies View Related

JDeveloper, Java & XML :: Customized Oracle Identity Manager

Dec 5, 2012

My company has a "generic information management platform" based on Oracle,

including:

Oracle Identity Manager 10g
Lotus
Oracle Internat Directory 10g
Oracle Portal 10g
Oracle E-Business Employee
Oracle E-Business User Management
Microsoft Active Directory
Mail System
Oracle Database

All above these systems constitute the generic information management platform.
---------------------------------------------------------------------------------------
There are 60,000 user records in the Oracle Database, lots of user records are duplicate, invalid and redundant. We want delete them by Oracle Identity Manager. But Oracle Identity Manager has no bulk deletion of users function!!!

So, we want customized development this generic information management platform, specifically customized development Oracle Identity Manager 10g's administrator interface.

We want add a JSP page, use this JSP page to bulk delete users. (user number > 60,000)
----------------------------------------------------------------------------------------
What's should we do? We can't directly manipulate the database to delete the users, all users are associated by API and exist in many systems.
----------------------------------------------------------------------------------------

View 1 Replies View Related

SQL & PL/SQL :: Functional Index - Catch Exception And Print Customized Message

Feb 16, 2011

I have a functional index.. which doesn't allow duplicate based on condition.I want to catch the exception and print the customized message but it always override my message.

create or replace function i_func
(tt_id in number,
d_date date,
stat in varchar2)
return varchar2
[code].....

output: ORA-00001: unique constraint (abb.TEST_IDX) violated

View 10 Replies View Related

Forms :: Database Connectivity After Putting Customized Login Form

Feb 12, 2010

I am having a application which is on Widows NT Operating system.I am using Oracle 10g Database, Developer suite 10g And 10g Application server.

My application uses Run_report_object to generate reports.Run_Report_Object is called in forms and Report server is configured in the same Application server where FMX are placed.

The report generation was working fine as long as oracle default login was used. When i created a form to handle login on my own, Report server is throwing "Unable to connect to database" error. My login forms takes the parameters from user and calls default logon command in on_Logon trigger.

View 1 Replies View Related

Forms :: How To Position Center Customized Logon Screen In Web Forms

Nov 20, 2012

I would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i

PROCEDURE CenterWindow (win_name VARCHAR2) IS
w_mdi NUMBER;
h_mdi NUMBER;
w_win NUMBER;
h_win NUMBER;

[code]...

View 3 Replies View Related

Forms Builder-exe Application?

Mar 8, 2010

if i can run an exe application ('Hello World!')from forms builder,is there a specific command?

View 1 Replies View Related

Forms :: Builder 10G Software

Mar 21, 2011

The Link for free download of Oracle Form builder 10g software ?

View 7 Replies View Related

How To Connect Oracle DB With C Builder 5.0 Application

Jul 27, 2010

i want to know how can i connect c builder application with oracle 10g express ? which components i have to use?

View 1 Replies View Related

Forms :: Oracle Graphics Builder 6i

Apr 22, 2011

I am using Oracle Form Builder and Graphics Builder 6i. In Graphics Builder I create a graph from this query view but in result my result is reverse which i want..

==============================================================
Create or Replace View V_Mnth_Attn as
select
emp_id, max(nm) name, max(cid) cmp_id, max(dpt) dpt_id,
min(case when to_char(dt_attend,'dd') = '01' then abrr end) "D_1",
min(case when to_char(dt_attend,'dd') = '02' then abrr end) "D_2",
min(case when to_char(dt_attend,'dd') = '03' then abrr end) "D-3",
min(case when to_char(dt_attend,'dd') = '04' then abrr end) "D-4",
[code].....)

because i want values in graph of all columns but i got only employee id on values and on get all values on x axis .

View 1 Replies View Related

Graphics Builder Canvas Resizing

Aug 8, 2011

I have designed a chart in graphics builder(v 6.0.5.0.8). I would like to call this chart in Oracle Developer Forms (v 6.0.5.0.2).

I use run_product command which works well and the chart is opened in a big canvas. There are too much blank spaces in the canvas out of the chart area. What I would like to do is I just would like to see chart area and make this flexible depending to the data presented on it.

View 1 Replies View Related

Forms :: Oracle Translation Builder

Nov 7, 2005

Trying to translate FMB (Base Language-English Translation language-French) . Have followed all the steps as given in a metalink Note:70117.1

Create a project and module and add a version and add a translation and then export the strings to same fmb

As per the note I should see the french labels etc when I set the NLS_LANG as FRENCH_FRANCE.WE8ISO8859P1 and run the form But I still see the English labels.

What am I missing ,

-- The note points out to install French Fonts but I don't know which fonts to install and how to install them from ?
-- Also Do I need to select a french font and script using Edit > Change Translation Font in the Translation Editor before exporting the strings ?

View 7 Replies View Related

After Conversion 11G Very Slow - Power Builder Application?

Dec 19, 2011

We converted our Power builder application from Oracle 10g to Oracle 11g. We are getting very slow to retrieveing data from the server.Basically we have noticed the following system internal sqls taking more time during our sql calls.

My schema Name : CMATISPROD
Oracle Version : 11.2.0.2.0

Indexes are moved separte table space.how to resolve this problem.

SELECT index_name, uniqueness
FROM SYS.all_indexes
WHERE table_owner = 'CMATISPROD' AND table_name = 'EXPRESSIONS';
* Formatted on 2011/12/15 14:19 (Formatter Plus v4.8.0) */

[code]...

View 3 Replies View Related

Reports & Discoverer :: WITH Clause In Report Builder

Jun 12, 2013

I'm trying to have RB use the following query:

WITH MY_DATASET
AS (SELECT /*+ materialize */
DISTINCT
N.NAME_ID NID,
NVL (TO_CHAR (RN.CONFIRMATION_NO), 'ACCOMPAGNATORE') CONF,
RN.RESV_NAME_ID,
MEV.TAX1_NO PARTITA_IVA,
[code]....

But although perfectly working in SQLDeveloper, RB returns an ORA-942 table does not exist error, pointing at MY_DATASET as the offending name.

View 8 Replies View Related

Reports & Discoverer :: Any Way To Pass Delimiter In Builder

Dec 15, 2010

I need to produce Excel spreadsheet from report builder.currently I am getting a format like,

ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;

This format when opened in Excel does not group in separate columns resulting in all getting mixed up.I am looking a format like,

ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,

This opens up clearly on excel. items like Product,Count are shown on separate columns along with the value.I am still looking into delimited formatting.

View 2 Replies View Related

Forms :: Builder Debugger Dialog Box Server Name

May 31, 2012

I notified some strange behaviour of my forms debugger. When I insert debug.attach piece of code into ma form and fired them on Windows machine after inserting into Oracle forms builder debugger dialog box server name (usualy ip) and given port from oracle forms window then everything works fine, breakpoint is catched. But when I changed my OS to RedHat then I am not able to come into all kind of trigger form code. Only program units could be debugged.

View 7 Replies View Related

Forms :: Creation Of Master Details Using Builder 6i

Oct 11, 2010

1.steps to create master-detail form using form builder 6i ,db oracle 9i.

2.Using dept and emp(database table)

3.one more thing difference between cascading/isolated while creating relation b/w dept and emp using join method

View 6 Replies View Related

Forms :: Oracle Translation Builder Not Working?

Feb 9, 2013

i want to use oracle translation builder to translate forms and reports from English into Arabic i run run the script SQLBLD and create new db connection an finally create a new project when am trying to import module i got the error NX-00201

View 3 Replies View Related

Forms :: Builder 6i - Layout Editor Crashes?

Sep 19, 2011

I installed forms builder 6i as I am making a change to a custom form which was created in 6i. When I attempt to use the layout editor, it crashes immediately. The dll module that it seems to get stuck on is uiw60.dll. I have this file on my machine. I added the directory location to the FORMS60_PATH in the registry as it was missing but I am still crashing. The version of 6i I have is 6.0.8.11.3.

View 1 Replies View Related

Forms :: Unable To Open FMB File In Builder?

Jan 30, 2012

I am using forms 10.1.2.0.

I am try to open one .fmb file but file is not open in form builder.Its shows message "cannot open file".

I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.

View 4 Replies View Related

Oracle Warehouse Builder 11.2 - Deploy To New Repository?

Feb 24, 2012

I have a big probleme with owb 11.2.

1. I have export MDL file from owb 10.2
2. I created owb repoisitory on server where I have installed my database 11gr2.
3. I have installed OWB 11gr2 on another machine.
4. Imported MDL file to new repository.

How I deploy to my new repository?

View 2 Replies View Related

Forms :: Use Trunc Function In Form Builder

Aug 6, 2011

i have problem when use trunc function in form builder i have two cloumn first column inserted data is 15.55 and i want the secound cloumn the will be too 15.55

i used this code but nothing happened

select sum(trunc(item_name,2)
into column2
from table_name

always the result be 16 i want it 15.55 without any round to this value

View 3 Replies View Related

Forms :: Builder 9.0.4.0.33 - Call Report From Form

Nov 11, 2011

I used Report Builder 9.0.4.0.33, and i want to call 1 report name is "DOCK_RECEIPT.rdf" from Form when click into button name is "Print". I write code in When-button-press follow: This is code call report from Form.

Declare
pl_id paramlist;
Begin
pl_id := get_parameter_list('tmpdata');
[code]....

On report "DOCK_RECEIPT" has parameter same parameter on Form. But when i click button "Print" then can't call report,while form and report that together folder.Now, i want to question, how must configure report builder for call report from form that? example: about directories,path, etc

View 4 Replies View Related

Forms :: Oracle Builder Object Navigator Reports

Nov 16, 2011

I am using Oracle Forms Builder 6i. When you open it, in the navigator tree:

- Forms - MODULE - Reports

I want to know what is the purpose of REPORT section in the Forms Builder.

View 6 Replies View Related

Reports & Discoverer :: Builder Crashes While Inserting Graphs?

Aug 8, 2012

My report builder crashes if I try to insert a graph from tool pallete.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved