I gang

Write a piece of Oracle dynamic SQL

Requirement

I need a dynamic piece of code that will create a select statement based on the following:

I have an oracle table(ANALYSE_DATA) with 2 columns, Object_type, Field_name, Tick_Ind.

Object_type (Will be VIEW or table)

Field_Name is a name of a column

Field_name is a Tick_box that inputs a Yes and No

I need a dynamic piece of code that will generate a select statement that is run by selecting from this ANALYSE_DATA table

and then select the appropriate fields that are ticked from the appropriate table/view.

The select will be very basic with one condition.

So the final generated message from the dynamic piece of code will be

Select field1, field3, field4, field7

From table1

Where (field1 is null or field 3 is null or field4 is null or field7 is null)

Thanks

Færdigheder: Oracle

Se mere: sql code oracle, oracle sql with, sql final, sql view table, sql dynamic pdf, write piece, piece code, oracle generate, wordpress sql dynamic charts, oracle create table, select oracle, dynamic table, create table oracle, write view sql, dynamic fields, write code basic, dynamic field, write requirement, sql view, sql table field, sql dynamic pages sql, piece, oracle column based data, sql create view, sql dynamic data exchange

Om arbejdsgiveren:
( 16 bedømmelser ) Sandton, South Africa

Projekt-ID: #6052149

Tildelt til:

dhiren707

I can definitely do this for you. Please open chat session as I am not able to understand the requirement clearly. Do you need a stored procedure?

$30 USD in 2 dage
(1 bedømmelse)
1.2

3 freelancere byder i gennemsnit $33 for dette job

smshafiqulislam

A proposal has not yet been provided

$25 USD på 1 dag
(14 bedømmelser)
4.4
vanpham

A proposal has not yet been provided

$45 USD på 1 dag
(0 bedømmelser)
0.0