I\'ve written a solution to problem using PL/SQL and SQL and I开发者_如何转开发 can\'t help thinking that it could be done 100% in SQL but am I am struggling to get started.
I have a sql function in oracle create or replace function testfunc..... Compile it succesfully. When i verify all_procedures system开发者_高级运维 table it\'s not there.
I have created a \'bottom-up\' tree in my SQL database tables where each element has a column for a reference to its parent.Now I am trying to find out if there is an easy query to get all the parents
i have a Windows Serv开发者_JAVA技巧er on which there is already a Oracle 10g client with tnsnames.ora and access to many databases.
I have installed Oracle 10g and now want to insta开发者_运维知识库ll 11g also...How can I do it?.. I know that ORACLE_HOME environment variable need to be configured for each \"oracle\"..
I have a table like casesopen/closecount ----------------------------- Aopen10 Aclose15 Bopen6 Bclose4 I need to get a result table that is like开发者_Python百科
I have a table TABLENAME with COLUMNNAME data type is CLOB. For example it\'s contains only 3 rows with 1s开发者_StackOverflow中文版t row of COLUMNNAME value is 123,456,789 and the 2nd is NULL and the
I only have the basic O开发者_开发百科racle tools available, i.e. SQL Plus, and I need to find out if a table was created with the ROWDEPENDENCIES option. It\'s a 10g database.
I have an app that stores times in GMT, but associated with airports which have Olsen tz names like \'America/New York\'.
I am very new in working with GIS or geometry data. I have geometr开发者_如何学编程y data (polygon) in oracle10g database. Is there any Spatial function to find a point inside that polygon. If not the
加载中,请稍侯......