Is it possible to append text to an oracle 9i clob without rereading and rewriting the whole content?
I\'m trying to compile an old piece of software which includes the use of the ProC pre-compiler for Oracle.
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.
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
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:
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.
I have 2 sql scripts ...1 to create a package, The ot开发者_如何学编程her to create a package body.
I am trying to create a query where, depending on a variable, results included are a result of one of three conditions:
We have a table which has three columns in it: Customer_name, Age_range, Number_of_people. 1开发者_如何学Go1-510
I would really appreciate a bit of help/pointers on the following problem. Background Info: Database version: Oracle 9i