sql developer Oracle script

$10-30 USD

Completed

Posted

almost 8 years ago

$10-30 USD

Paid on delivery

From the pdf you can see that there are the first 4 columns that are holding duplicated values. I want to 'distinct' these 4 feeds so they only hold one value of each (that should appear at the top) . The other fields menu_name, permission_code and description need to remain 'as is'. You can see the sql script that has been written at the top so this just needs 'added to'. Note - that I want to be able to export the output to xml so I will need to be able to use the /xml/ into the 'select statement. What I am saying is that I do not want it converted to a pl/sql script. It has to be understandable and the output must be able to be easily exported into an xml file. Please do not bid if you do not understand this, thanks. Also note this is Oracle sql developer.

SQL

Project ID: 10826704

About the project

8 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@makert40

$25 USD in 1 day

3.7

(3 reviews)

2.6

8 freelancers are bidding on average $29 USD for this job

@vinaysinghh

A proposal has not yet been provided

$35 USD in 1 day

4.6

(14 reviews)

3.8

@hopesourav

can do it ... pay after completipn

$30 USD in 2 days

0.0

(0 reviews)

0.0

@itbarduga

Hello, Myself Barduga, I have been working Oracle Database SQL and PLSQl from past 15 years and have developed many queries. The specific thing you are looking is getting the distinct of the the first for columns and the rest of the columns to repeat. I could deliver sql query which basically returns the data in XML format, which will have the below structure: <AccessControl> <users> <userName></userName> <firstName></firstName> <lastName></lastName> <roleName></roleName> <menuList> <menu> <menuName></menuName> <permissionCode></permissionCode> <description></description> </menu> </menuList> </users> </AccessControl> I hope i have provided the structure of the XML as per your requirement. Query can be written to get this output as XML. Regards Barduga

$30 USD in 1 day

0.0

(0 reviews)

0.0

@christophernobl4

Hi, I'm new to freelancer but I have over 10 years of experience in the IT field. I can develop a solution for your issue, I would just need a little more info on the XML part. thank you for your time.

$30 USD in 4 days