Oracle

Encrypting columns for some users
Hi, 10g Here is an unusual need: some users with read access to a table must see the data in some specific columns as gibberish, while other users still must be able to see them as clear text. It has to work with sqlplus as well as other query tools. Any idea? TIA ... 11 Jul 2008 07:52

Multiple Queries
Morning! I have to write a procedure which will accept a record type and the number of records to return to the calling PHP script. We have a similar script which gets data from a single query and opens a SELECT statement for PHP like this: OPEN line FOR v_query; But in this case, I may get multiple pairs... 10 Jul 2008 11:20

Recovery Manager (RMAN) problem
Thank you guys for all of your opinions/sugestions. As for now, the solution described by me at the beginning of this post has been frozen by the customer. It will not be implemented soon. Regards, Krystian ... 10 Jul 2008 10:18

100% memory
Hello, Have a 10G server on solaris 10 sparc with 16GB. An alarmed user has pointed out that the memory usage look very high. I dunno whether the memory usage is just high or too high because dont have previous experience on sol10/10g. Any other commands to run to get more insight? TIA Martin [alant(a)milan ... 22 Jul 2008 18:52

PL/PDF: Outputting HTML formatted text
Hi I'm using PL/PDF (http://www.plpdf.com) to generate PDF documents. This can output a string using the command plpdf.PrintFlowingText(6,l_clob); In this case, 6 is the text size, and l_clob is a CLOB variable containing an HTML document. Does anybody know of a utility which will take the HTML text (con... 10 Jul 2008 06:11

Deadlocks with block - 0, slot - 0 during INSERT
Hi We are getting strange deadlocks in 9.2.0.7 database: 1. They occur during INSERT into range-partitioned table where all indexes are local. 2. Both sessions were trying to execute the same SQL statement. 3. ObjectID point to table partition and index (primary key) partition corresponding to this table partit... 10 Jul 2008 14:26

Could I use user define function as default value of a column?
On Jul 8, 8:01 am, "Jack.Lee" <gzjack...(a)gmail.com> wrote: I wanna add a user define function as default value of a column.But oracle raise an error.Could I do that? Thanks a lot! Jack.Lee Take a look at Virtual Columns in 11g. It might not be exactly what you're looking for, but it is incredibly use... 9 Jul 2008 15:46

Counting Strings
Hi, We are running 10g r2. Too bad REGEXP_COUNT does not work. I need to count the occurances of a string within a string. It works from when used in a select from a table: SELECT LENGTH(c1) - LENGTH(REPLACE(c1, 'Oracle', 'Oracl')) FROM x; This gives me a result of 4, which is correct. However, what if ... 10 Jul 2008 13:24

Oracle with Crystal Reports 11.5.3
Hi, I am trying to develop a report to call an oracle stored procedure contained within a package and am having major trouble in that crystal cannot seem to determine the output ref cursor at all... I think I have tried just about everything!!! Here is my code: Package spec: CREATE OR REPLACE PACKAGE p_Trad... 10 Jul 2008 21:39

PL/SQL issue with invalid results
I can run a query in SQPLUS and get results I need. Select col1 From tab1 sch, tab2 cmn where and cmn.joinid = sch.joinid AND completion_dttm > TO_DATE('06/30/2008', 'MM/DD/ YYYY') AND completion_dttm < TO_DATE('06/30/... 9 Jul 2008 15:46