Terminé

Oracle View question

I need assistance in creating a view.

Table: cm3rm1

prgnnumber char(50)

change_type char(50)

closure_code char(50)

us_affected char(1) - can be "t" for true and "f" for false

uk_affected char(1)

de_affected char(1)

ch_affected char(1)

I have the following problem: I want to create a cross-table (pivot) report over closure_code and company affected (*_affected).

Now I have the problem that the one or multiple *_affected fields can be "t" and not only one at same time.

If it was only one at same time, then I would be able to create such a cross-table report.

Idea is:

If I had a table where you have one record for each *_affected="t", then I could create my cross table:

Should look like this:

record_id (float) - auto increment

prgnnumber char(50)

change_type char(50)

closure_code char(50)

country_affected (50) - for example: "UK", "USA", "DE", "CH"

for example, if one record has two *_affected fields="t" then I would need 2 records in this table.

Can this be done over a table view?

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

SQL

Compétences : Ingénierie, MySQL, Oracle, PHP, Architecture Logicielle, Tests de Logiciels, Traduction

en voir plus : working for oracle, sql to oracle, sql code oracle, package sql oracle, package oracle example, package example in oracle, oracle sql package, oracle for hire, working at oracle, view source, oracle install, Oracle functional , multiple question, creating question, multiple question sql, sql multiple question, legal translation company, sql view table, multiple oracle sql, sql question

Concernant l'employeur :
( 221 commentaires ) Mannheim, Germany

Nº du projet : #3493081

Décerné à:

ramasubra

See private message.

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(8 Commentaires)
3.4

8 freelance font une offre moyenne de $45 pour ce travail

phasefiveso

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)
6.1
goldenscript

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.1
goldcoastvw

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
2.9
softica

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
0.8
orapkj

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
dcom99

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
harinisoftware

See private message.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
0.0