oracle9i
How to append text to an oracle clob
Is it possible to append text to an oracle 9i clob without rereading and rewriting the whole content?[详细]
2023-03-23 22:29 分类:问答Oracle 9 ProC precompiler segfault while reading pcsus.msb
I\'m trying to compile an old piece of software which includes the use of the ProC pre-compiler for Oracle.[详细]
2023-03-23 06:24 分类:问答PL/SQl question, oracle 9i
Ok guys, we have a situation here in our project. We have an order which customer placed, and it gets split into multiple orders. We need to find out how many orders it got split into.[详细]
2023-03-21 05:36 分类:问答How to analyse the oracle statspack which is in the html format?
I have a html version of the Oracle Sta开发者_运维百科tspack report.I am trying to interpret the data on the report to extract a number of different values but I\'m not sure where to look.In particula[详细]
2023-03-20 07:26 分类:问答ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
When I have a sql statement like select * from table1, it works great, but as soon a开发者_开发百科s I put it into a function, I get:[详细]
2023-03-19 14:04 分类:问答Oracle query not displaying date properly
In Oracle, there is a column(dateColumn) in a table with column type = DATE and the value for a particular record is showing as \'10/03/2010\' when I do a select * from table.[详细]
2023-03-18 22:06 分类:问答What is the order of running these sql scripts?
I have 2 sql scripts ...1 to create a package, The ot开发者_如何学编程her to create a package body.[详细]
2023-03-14 22:26 分类:问答SQL with 3 conditions with join: "where X in(foo)", "where X not in(foo)", or no "where" rule
I am trying to create a query where, depending on a variable, results included are a result of one of three conditions:[详细]
2023-03-14 21:36 分类:问答Pl/SQL - oracle 9i - Manual Pivoting
We have a table which has three columns in it: Customer_name, Age_range, Number_of_people. 1开发者_如何学Go1-510[详细]
2023-03-13 01:21 分类:问答Is there a way to find all distinct values for multiple columns in one query?
I would really appreciate a bit of help/pointers on the following problem. Background Info: Database version: Oracle 9i[详细]
2023-03-11 06:34 分类:问答
加载中,请稍侯......