[Gvsig_english] Re: Gvsig_internacional Digest, Vol 23, Issue 18

[Juan Lucas Dominguez Rubio]

Hello,
 
"Is useful to have even a textarea to write a specific sql query to do somethink on the fly."
 
There is already a text area to write a SQL restriction when you open an Oracle table. That's not what you mean? In which other moment would you like to enter a restriction? Was it a suggestion or a praise? (= è un suggerimento o un elogio?)
 
"So I think is better to do a "select distinct ..." when the layer is on a DB."
 
Thank you. We're going to investigate in which part of gvSIG we should add the expression SELECT DISTINCT...
 
Regards
 
Juan Lucas Domínguez Rubio
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Andrea Peri
Enviado el: lun 24/12/2007 13:12
Para: gvsig_internacional at runas.cap.gva.es
CC: Andrea Peri
Asunto: [Gvsig_english] Re: Gvsig_internacional Digest, Vol 23, Issue 18



Hi,

You can use USER_SDO_GEOM_METADATA joined with all_tables and with
Because of course sometime the table cannot be register on user_sdo_geom_table

select
        a.table_name,
        b.column_name,
        b.data_type
from
        all_tables a,
        all_tab_columns b,
        user_sdo_geom_metadata c
where
        a.status='VALID'
        and
        a.dropped='NO'
        and
        instr(a.table_name,'$')=0
        and
        a.owner='S3DUMP'
        and
        a.table_name = b.table_name
        and
        ( b.data_type='SDO_GEOMETRY' OR b.data_type='SDO_TOPO_GEOMETRY' )
        and
        c.table_name = a.table_name

Another two suggestions:

Is useful to have even a textarea to write a specific sql query to do somethink on the fly.

And I notice when the rendering is choose to do a simbology on all distincts values of a field,
gvSIG start to find the unique values, like with a shapefile looping on all the values.
But on a DBMS this is a slow operation (more than a shapefile).
So I think is better to do a
"select distinct ..." when the layer is on a DB.

Best Regards,


On Mon, 24 Dec 2007 09:02:32 +0100, gvsig_internacional-request at runas.cap.gva.es wrote:

>We thought about the possibility of ignoring the XXX_SDO_GEOM_METADATA and finding out by other means which tables have geometries, but I think
it's a non-standard behavior and adds some risks (will it take very long? what is the full extent of the geometries of that table?)
>
>Nevertheless, maybe we could try it with the tables/views of the current user doing what you suggest.
>


_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6997 bytes
Desc: not available
Url : http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20071224/24db4dda/attachment.bin