same reseult set with less column

#1

I am trying to get the same resultset with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

#2

<dt1649651 (AT) yahoo (DOT) com> schreef in bericht
news:2cd18536-4ae7-4b4d-ad4e-e10bd3f8876e (AT) 25g2000hsx (DOT) googlegroups.com...

Quote:

I am trying to get the same resultset with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

If you don't have any access to the original query, you could try to trace
your session and see what it does, or investigate the SGA

Shakespeare

#3

<dt1649651 (AT) yahoo (DOT) com> schreef in bericht
news:2cd18536-4ae7-4b4d-ad4e-e10bd3f8876e (AT) 25g2000hsx (DOT) googlegroups.com...

Quote:

I am trying to get the same resultset with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

If you don't have any access to the original query, you could try to trace
your session and see what it does, or investigate the SGA

Shakespeare

#4

<dt1649651 (AT) yahoo (DOT) com> schreef in bericht
news:2cd18536-4ae7-4b4d-ad4e-e10bd3f8876e (AT) 25g2000hsx (DOT) googlegroups.com...

Quote:

I am trying to get the same resultset with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

If you don't have any access to the original query, you could try to trace
your session and see what it does, or investigate the SGA

Shakespeare

#5

<dt1649651 (AT) yahoo (DOT) com> schreef in bericht
news:2cd18536-4ae7-4b4d-ad4e-e10bd3f8876e (AT) 25g2000hsx (DOT) googlegroups.com...

Quote:

I am trying to get the same resultset with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

If you don't have any access to the original query, you could try to trace
your session and see what it does, or investigate the SGA

Shakespeare

#6

On Sep 26, 8:48*am, "dt1649... (AT) yahoo (DOT) com" <dt1649... (AT) yahoo (DOT) com> wrote:

Quote:

I am trying to get the same resultset *with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

What kind of business requirement drives this request?

Given: you do not know the original query until run time.
Implies: The original query is passed to you as text.
Therefore:
The only possible solution I can see is to parse the text.

Ed

#7

On Sep 26, 8:48*am, "dt1649... (AT) yahoo (DOT) com" <dt1649... (AT) yahoo (DOT) com> wrote:

Quote:

I am trying to get the same resultset *with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

What kind of business requirement drives this request?

Given: you do not know the original query until run time.
Implies: The original query is passed to you as text.
Therefore:
The only possible solution I can see is to parse the text.

Ed

#8

On Sep 26, 8:48*am, "dt1649... (AT) yahoo (DOT) com" <dt1649... (AT) yahoo (DOT) com> wrote:

Quote:

I am trying to get the same resultset *with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

What kind of business requirement drives this request?

Given: you do not know the original query until run time.
Implies: The original query is passed to you as text.
Therefore:
The only possible solution I can see is to parse the text.

Ed

#9

On Sep 26, 8:48*am, "dt1649... (AT) yahoo (DOT) com" <dt1649... (AT) yahoo (DOT) com> wrote:

Quote:

I am trying to get the same resultset *with an original query but one
last column less.

For example the original query is "select x,y,z from table1 where
condition1".

How can I get the resultset of "select x,y from table1 where
condition1" without knowing in advance the original query.

Thanks for your help.

DT

What kind of business requirement drives this request?

Given: you do not know the original query until run time.
Implies: The original query is passed to you as text.
Therefore:
The only possible solution I can see is to parse the text.

Ed

#10

On 26 Sep, 15:09, Ed Prochak <edproc... (AT) gmail (DOT) com> wrote:

Quote:

What kind of business requirement drives this request?

Given: you do not know the original query until run time.
Implies: The original query is passed to you as text.
Therefore:
The only possible solution I can see is to parse the text.

* Ed

I think it smacks of application-generated dynamic SQL. *shudders*

-g