Spatial :: Select Attributes In Point Cloud

Oct 10, 2012

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?

View 0 Replies


ADVERTISEMENT

Spatial :: Sdo_nn To Fetch Points From Point Cloud And Georaster

Mar 9, 2013

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.

View 21 Replies View Related

Spatial :: Extract Point Heights From TIN?

Jun 18, 2013

Like to know a easy method to extract height for a coordinate in the TIN.

View 0 Replies View Related

Spatial :: How To Get All The Values Of The SDO_ORDINATE_ARRAY Of A Oriented Point

Dec 14, 2012

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;

Result:
4691117          -75,5860886328133     6,17943526155142          (null) (null)

As you can see, it only obtains the X,Y values but not the values of the orientation vector, how can I get the values?

View 2 Replies View Related

SQL & PL/SQL :: Select Some Attributes From That Object In Same Query

Oct 25, 2013

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...

View 1 Replies View Related

SQL & PL/SQL :: Create Nested Query Within Select Of Attributes

Dec 21, 2011

I'm trying to create a sort of nested-query within my select of attributes . i.e.

select A.a,
B.b,
(select count(C.*)
from C
where C. = B.d
group by C.y)
from A a,
B b
where A.d = B.d
and ...

Over-simplifying my query:

select B.desc "Location",
F.desc "Source",
A.amt "Amount",
sum(G.G_CNT) "No. Units",
c.desc "Status"
[code]....

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.

View 8 Replies View Related

Cloud Service :: How To Import DB From Standard DMP File To Oracle Cloud

Mar 6, 2013

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?

View 1 Replies View Related

Cloud Service :: Can't Upload A Table With A SDO_GEOMETRY Column To The Cloud

Nov 28, 2012

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.

View 1 Replies View Related

Cloud Service :: How To Use Domain Name For APEX Application At Oracle Cloud

Feb 25, 2013

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?

View 7 Replies View Related

Cloud Service :: How To Migrate / Move Mysql Database Into Cloud

Jul 18, 2013

We have an application which is built on top of mysql DB. Now we are planning to move into Oracle DB cloud share some documents for this migration. 

View 1 Replies View Related

Spatial :: Select Repeating Values

Sep 7, 2012

some sample data in my point geometry table.

every POLYID has two rows with NAME value, i need to select the two rows if NAME is same for a given POLYID.

example: POLYID 4351 has same name N, then i need to select two rows with PILYID 4351.

POLYID POINTID           NAME
-----------------------------------------------------------------
4348 5763           N
4348 5764           F
4351 5741           N
4351 5756           N
4367 5721           M7

[Code]....

View 6 Replies View Related

Cloud Service :: Export To PDF (printing) From APEX In Cloud?

Mar 15, 2013

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)?

View 7 Replies View Related

Cloud Service :: Back Word Compatibly In Cloud

Dec 3, 2012

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 ??

View 4 Replies View Related

Cloud Service :: Local Development For APEX Cloud

Dec 4, 2012

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).

View 6 Replies View Related

Spatial :: Convert Shape File To Oracle Spatial

Jul 31, 2012

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,

View 2 Replies View Related

Spatial :: Error In Spatial Index

Jun 16, 2013

I created a spatial index on a table, but i get the error message:

ORA-13033: the data in sdo_elem_info_array of sdo_geometry is unavailable

How can i write a SQL command to delete those unavailable records?

View 2 Replies View Related

Spatial :: ORACLE 11g Spatial And GRS 80

Apr 4, 2013

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:

INSERT INTO
USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES
('INVENTORYGEOMETRY','INVGEO',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, .05),MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, .05)),8307);

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:

INSERT INTO
USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES
('INVENTORYGEOMETRY','INVGEO',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, .05),MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, .05),
(MDSYS.SDO_DIM_ELEMENT('FIXEDGRID_.5Resolution', 0, 26916, .5)),8307);

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.

View 4 Replies View Related

PL/SQL :: First Three Not Null Attributes

Oct 29, 2013

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. 

View 7 Replies View Related

PL/SQL :: How To Check Particular Attributes Exists Or Not In XML Tag

Aug 14, 2012

As per the earlier post,I am able to parse now.

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.

<?xml version="1.0" encoding="UTF-8"?>
<pi:Extract_Employees xmlns:pi="urn:com.workday/picof">
<pi:Employee>
<pi:Employee_ID>1100</pi:Employee_ID>

[Code]....

OUTPUT:
EmployeeID_ Name JobTitle_     Grade ActualComp_Change_
1100     Surana     Intern - Master¿s     A     500000
1000     roy     Intern - Master¿s     B     216000
1000     roy     Intern - Master¿s     00     266000

But my requirement is to display only those employeeID ,where Actual_Comp_Change tag having PriorValue attribute.

The required OutPUT should be :

EmployeeID_ Name JobTitle_     Grade ActualComp_Change_
1100     Surana     Intern - Master¿s     A     500000

is there any possibility to use ExistNode() function to the above quer or is there any alternative solution.

View 5 Replies View Related

SQL & PL/SQL :: Find Date When Attributes Modified?

Sep 14, 2012

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

[code]....

View 6 Replies View Related

PL/SQL :: Oracle Objects - Insert Particular Attributes

Apr 4, 2013

I'm using the below data base version

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

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 ?

View 9 Replies View Related

Identify Attributes For Customer / DVD And Rental Tables

Oct 29, 2008

wish to do a database on dvd rental in oracle following: for the ER diagram i have indetified the entities as : branch , emp, customer,dvd, rental...

1) set the one - many relationship in the above data
2) identify the attributes for customer,dvd and rental tables and thus normalise them as well.

View 2 Replies View Related

Client Tools :: Setup Attributes Of SQL PLUS Permanently?

Feb 7, 2011

Is it possible to set the below settings permanently?

1) In UNIX - DEFINE_EDITOR=VI
2) SET SERVEROUTPUT ON
3) SET LINESIZE n

How to set the AUTOCOMMIT on/off, while using PLSQL Program.

View 3 Replies View Related

Reports & Discoverer :: Destype Parameter Attributes

Oct 21, 2011

Attributes required on the destype parameter list. This attributes are like PRINTER

EXAMPLE:
ADD_PARAMETER(listap,'DESTYPE',text_parameter,'PRINTER');

View 1 Replies View Related

ODP.NET :: Null Values In (ref) Attributes - C# Odp Type Factory?

Nov 22, 2012

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?

View 0 Replies View Related

Cloud Service :: DB Hosting Specifically APEX?

Oct 3, 2012

if APEX hosting allows access to the file system so that access to javascript, css and images files can be passed to a webserver?

What webserver comes with hosting - is this the Apache 1.3 that comes with 11g?

View 6 Replies View Related

Cloud Service :: Constraints Not Created When Using A Cart?

Oct 16, 2013

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.

In log I can see error messages like:

Error starting at line 5 in command:

ALTER TABLE "EMPLOYEES" ADD CONSTRAINT "EMP_DEPT_FK" FOREIGN KEY ("DEPARTMENT_ID")      REFERENCES "DEPARTMENTS" ("DEPARTMENT_ID") ENABLE

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

[code]...

View 0 Replies View Related

Enterprise Manager :: Upgrade 11g Grid Control To 12c Cloud?

May 29, 2013

Now we have 11G grid control on linux x86_64 server and we are planning to upgrade this to 12c Cloud control,

What are the available options,

1) upgrade from 11g to 12c on the same server.

2) Build another linux server and install 12cloud.

which ever is easy to have 12c upgrade. oracle recommended url's to follow the installation.

View 4 Replies View Related

Cloud Service :: Controller Installation - Linux Version For 12c

Nov 14, 2013

what is the recommended "LINUX" version for 12c cloud controller installation?

View 0 Replies View Related

Cloud Service :: Adding Packages To Cart In SQL Developer

Jan 14, 2013

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.”

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved