Re: make sql query without crosstab

is it good practice to create temporary tables for querying only?


aljohnssngp@xxxxxxxxxxxx wrote:
Thank you for the valuable replies
I dont have Oracle complete reference,so no information on this is
avilable.

so change in table field structure will make it easy for me.

but it will contain duplicate values.but qurey will be easy


David Cressey wrote:
"Bill Karwin" <bill@xxxxxxxxxx> wrote in message
news:ecvlea0194@xxxxxxxxxxxxxxxxxxxxx
aljohnssngp@xxxxxxxxxxxx wrote:
the groups may be unlimiting numbers

Groups ID 1,2,3,4,5..... and same in catagory

So I guess you need a crosstab for any and all group id's that occur in
the data. This is hard to do in SQL. In general, you need to know each
distinct value so you can make a column for each one. There is no way
to query for a variable number of columns. SQL does not know how to
produce additional columns for you.

Regards,
Bill K.

For a more complete treatment the OP can look in "Oracle: The Complete
Reference" for a section entitled "Turning a table on its side". What its
really discussing is crosstabulation.

.

Relevant Pages

  • Re: make sql query without crosstab
    ... so change in table field structure will make it easy for me. ... So I guess you need a crosstab for any and all group id's that occur in ... This is hard to do in SQL. ... For a more complete treatment the OP can look in "Oracle: ...
    (comp.databases)
  • Re: make sql query without crosstab
    ... i think the change in table field structure will make it easy for me. ... So I guess you need a crosstab for any and all group id's that occur in ... This is hard to do in SQL. ... For a more complete treatment the OP can look in "Oracle: ...
    (comp.databases)
  • Where to start to become a DBA
    ... I am Dhanasekar. ... become a DBA.i dont have any idea about oracle dba.please suggest me, ... I dont have knowledge in Softwares like sql.., ...
    (comp.databases.oracle.server)
  • Re: Limit of 1050 columns for ANSI joins
    ... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
    (comp.databases.oracle.server)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)