I have data in point cloud (x,y,z,a,b,c,d (a,b,c,d are some attributes about this point)). i create a point cloud (sdo_pc - geometry), block tables (sdo_geometry - geometry). if i use a function to_geometry, result is only in multi point without attributes. it is way display this 3D data, and at the same time inquire of concerning for a attributes in concrete points?
I have a requirement to fetch the nearest neighbor from a given point coordinates inside a point cloud/georaster data. how can i retrieve a collection of all neighboring points from a given point.
I guess i will have to use sdo_nn operator. how to use the operator to achieve the result.
I'm trying to get the values of a Geometry which is an Oriented Point. To that, i'm using SDO_UTIL.GETVERTICES, but this utility only obtains the point X,Y, it doesn't obtain the values of the orientation vector.
The Geometry is this: MDSYS.SDO_GEOMETRY( 2001,8307,NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1,3,1,0), MDSYS.SDO_ORDINATE_ARRAY(-75.586088632813272,6.1794352615514194,0.57278169530235967,-0.81970795380217887,0) )
The query is this: SELECT c.ipid, c.nombre, t.X, t.Y, t.Z, t.W FROM Hidrantes c, TABLE(SDO_UTIL.GETVERTICES(c.geometria)) t where c.ipid = 4691117 ORDER BY c.ipid, t.id;
He had created an object type and wanted to populate it in a query. So far so good. But then he wanted to select some attributes from that object in the same query. Basically, he wanted to do something like this:
With his_view As ( select object_type( attr1, attr2) theobj From his_table Where ... ) Select theobj.attr1 From his_view
But somehow he was hitting ORA-00904: "THEOBJ"."ATTR1": invalid identifier over and over again.Here's a test script:
Create type mhe_type As Object( col1 Number , col2 Varchar2(30) ) / -- Basic select With mhe_view [code]...
Specify a correlation name, which is alias for the table, view, materialized view, or subquery for evaluating the query. This alias is required if the select list references any object type attributes or object type methods. link...
I need to incorporate a count of the number of units from TableG that have a certain status. I tried the following but when I tried to run it, I get an error saying that it's not a Group By expression -the red part is highlighted in TOAD.
select B.desc "Location", F.desc "Source", A.amt "Amount", sum(G.G_CNT) "No. Units", (select count(*) from TableG G2 where G2.D_ID = D.ID and G2.status = 10 group by G2.D_ID)"Count", c.desc "Status" [code]....
Any thoughts how I can incorporate a query in my select of attributes?how to Group By something.
I am testing the Oracle Cloud in a trial mode.. I have created the Oracle user and would like to restore my existing (non Oracle Cloud) database from the standard DMP file (import dmp). In all references that I could find [URL}... and that was given to me by the Oracle Cloud support service I couldn't find the definite answer on a simple question: if I have a DMP file of my own database, can I and if yes, then how I can import this DMP file to my new Oracle Cloud database? some link on "step by step" instruction, if such exists. If there is no such a way, then what way should I use?
I followed the "Loading data into your database cloud service from SQLDeveloper" tutorial, and I cannot upload a table that contains a column of type SDO_GEOMETRY. I get an error message that reads: "Unsupported Cart Object: Unable to deploy some objects to the cloud. These objects have been deleted from inclusion. Review Cart contents before redeploying. The following have an unsupported data type: SPATIAL.FLIGHT_TRACK." I can load any table that does not contain a n SDO_GEOMETRY column.
1. I have for example my-custom-domain.com and want that my customers use this domain to login at APEX Application at Oracle Cloud. I don't want that my customers see
[URL]........
and see instead of my-custom-domain.com :)
How I can do it? Don't find any technical information about it...
2. Can I use my ssl certificates for my domain for Oracle Cloud Instance?
I can configure in trial account interactive report for print but Print attribute section contains message: Report printing is currently not available, there is no print server configured.It will be possible to use this option in non-trial version? If yes which type of print server is configured in this version (FOP or BI Publisher)?
As you know, Oracle Cloud runs Apex 4.1..In my premises I am running Apex 4.2...Normally, we cannot import apps exported from apex 4.2 into Apex 4.1. I am planing to move to Oracle Cloud... Can I import Apex app, which were exported from apex 4.2, into Oracle Cloud ??
If it is not compatible, then that means, I cannot move to the cloud now. When can I expect Oracle Cloud to upgrade to APEX 4.2 ??
I would like to develop an APEX cloud app locally and offline (my PC). Later, I'll deploy it to the cloud for testing when finished. I understand that the APEX/DB in the cloud only provides a sub-set of the features of a local APEX/DB installation. To make sure I develop a solution that will run in the cloud and not depending on features not supported, I would like to set up my local PC with the same limitations as the cloud instance. Is there a script/patch etc. that can be run to limit local features (or privs to them) to mimic the same premises and enviroment as when running in the cloud? (I know such exists for MS Azure local development).
I have a road network which is shape file format and i want to export it to oracle spatial format using any free tool, I am using arcgis 9.3.1 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bi,
I am working on a project that will require both projected coordinates and geographic coordinates for different product files coming in. I have no issues defining, storing, extracting or matching the geographic coordinates. My columns for those coordinates with SRID 8307 are defined in the user_sdo_geom_metadata table as follows:
the index: create index "MYDB"."INVGEO_IDX" on "MYDB"."INVENTORYGEOMETRY"("INVGEO") indextype is MDSYS.SPATIAL_INDEX;
how I am going to have a column that has both Geographic and Projected coordinates. Am I allowed to define more SDO_DIM_ELEMENT(s) fro the SDO_DIM_ARRAY with different min/max values. As an example, would I be able to still use an SRID of 8307 for both WGS 84 and GRS80 data (ellipsoid), something like the following:
Is that possible or do i have to create a new column in the database? Also, I don't know the relationship between the SDO_ELLIPSOIDS table and the SDO_GEOMETRY table.
how I'm going to make this work for both the geographic and projected coordinates or if I'm going to be able to make it work.
MY requirment is: I want the first three nullable attributes. For Eg: If I have 60 columns in table, I need to fetch the first three null data in a row.
i have also another concern as per below xml file.
My requirement is to identify perticular node ,whose having PriorValue attribute present in <pi:the Actual_Comp_Change> tag,those record should return.
The requirement is to find the last date when either ATTRIB1 or ATTRIB2 were modified for each ID. There are many other columns in the table, but I'm not interested in other columns.
Test Case
SET LINES 100 SET PAGES 100 DROP TABLE test_log / CREATE TABLE test_log
[code]....
Expected Output
ID LAST_CHANGE_DATE ---------- -------------------- 11 02-SEP-2012 10:58:32 35 05-AUG-2012 10:58:32
I have written the below query, to get the required output.
SELECT MAX(i_date) last_change_date FROM ( SELECT seq,id, attrib1, attrib2, i_date, row_number() OVER (PARTITION BY attrib1 ORDER BY i_date) rn1, row_number() OVER (PARTITION BY attrib2 ORDER BY i_date) rn2
I have created a pl sql type as object with five attributes as below.Now im trying to insert only 3 attributes with the attribute names ( As like insert into statement with column names).
Create type address_test as object ( Streetno varchar2(20), Locality varchar2(20), City varchar2(20), Pin varchar2(7), Country varchar2(20)) [code]....
Is that possible to use attribute names in the insert statement of column object type ?
I'm using the odp.net type factory (class IOracleCustomType and the specific annotations...) to map udts to c# classes.By now I had no problems with it, because I've never used "ref" attributes within the udts.Now I need the use of "ref" attributes within udts but it seems that the odp factory cannot handle those references.
For example:_*
A Simple Type: create or replace type bookcontent_t force as object ( id number(20) , name varchar2(1000) );*And a collection with references to objects of this type:*
create or replace type fms_bookcontent_ref_cln force as table of *ref* bookcontent_t;The c# class is generated by odp.net.
When I retrieve data by using odp.net I get a collection with the correct number of elements but the values are null.What can I do to solve this problem with "ref" attributes/lists? How can I get the referenced object instances?
have created a cart in SQL Developer with all the tables from HR schema. If I apply the cart to my database cloud service the tables and data are there but most of the constraints are missing.
Error report: SQL Error: ORA-02270: no matching unique or primary key for this column-list 02270. 00000 - "no matching unique or primary key for this column-list" *Cause: A REFERENCES clause in a CREATE/ALTER TABLE
I am really wondering about data loading to the cloud, I've just read the documentation, but regarding the packages, I have more than 100 package and I have to "add to cart" one by one the problem is that the package body is not added by default, so you have to expand the packages one by one then select the package body right click and add to cart. This task is very tedious, is there any other options.”