art's articles:

Items(78) /8 Next >> Last >|

Comparing Tables 9 32 (9/21/2012 11:29:48 PM) comp.databases.oracle.server Hi, I am using this SQL to perform some simple table compares: data_rec=`sqlplus -s $user/${password} << "EOF" set heading off feedback off verify off timing off SELECT COUNT(*) FROM (SELECT... The

Nested Table Query 8 30 (9/11/2012 2:08:59 PM) comp.databases.oracle.server Hi, I'm trying to do a INSERT INTO (SELECT........ The table I am inserting into and the table I am selecting from have the exact same layout. However, both tables have nested tables within. I'm havin... The

ADRCI in 11g 2 36 (9/11/2011 12:55:06 AM) comp.databases.oracle.server Hi, I've noticed that the PURGE command in the new Adrci seems to work rather strangely. It does not seem to operate on the contents of the log.xml, but the actual file date / time. So, if my alert log gets... The

Query question #6 6 42 (8/30/2011 5:57:31 PM) comp.databases.oracle.server Hi, We have a massive query. But there is a problem. One of the subqueries does not return any rows, therefore the entire query returns no rows. I need to make it is one of the subqueries has no results, th... The

Counting Records 3 40 (8/1/2011 3:16:08 PM) comp.databases.oracle.server Hi, I have a table with 3 nested tables in it. I want to be able to return the number of rows retrieved from each nested table in my result set. This cannot be just a simple count, as if the nested tables ha... The

Subquery 4 41 (4/13/2011 1:52:25 AM) comp.databases.oracle.server Hi, I have this query / subquery that is acting strange. I am trying to get the latest status of a customers Trial subscription and Paid subscription. The customer may have 1, both or neither. But, in the ca... The

RMAN Archive logs 6 52 (4/5/2011 6:19:35 PM) comp.databases.oracle.server Just a question about RMAN. We have the 'include archive logs' clause in our configuration. Problem is sometimes out archive destination location gets filled. So, I wrote a script to move them to the RMAN l... The

Query from array? 1 122 (3/8/2011 6:39:06 PM) comp.databases.oracle.misc This is kind of funky. But the application uses what looks like these PIPE ROW functions and uses that as a loop driver: FOR v_rec IN (SELECT * FROM TABLE(data_list_functions.pipe_data_list_100()) WHERE... The

SSH & Linux 4 154 (2/6/2011 1:08:57 AM) comp.os.linux.setup Please, someone help me. I'm going nuts. I have Cent OS 5.x installed, which comes with SSH 4.3. I want to upgrade that so I can use Chroot & Jail. But, no matter what instructions I follow, what I inst... The

Anyone use Postfix? 1 72 (11/23/2010 3:34:20 PM) comp.unix.programmer Hi, We have 2 servers, an Apache server and a Postfix server. We have PHP scripts that run on the Apache server and send out email. That server never receives email, or at least should not. Our firewall s... The

art's replies:

Items(37) /4 Next >> Last >|

Loading 4 20 (10/18/2009 12:35:54 AM) comp.lang.php Hi, I'm trying to find an example of a 'loading page' that I can use with a transparent image. Basically the user clicks on the 'SAVE' button and which the data is being saved I want to display this image an... art (172)

Materialized View #4 3 37 (10/23/2009 11:56:38 PM) comp.databases.oracle.server Hi, Hope I can explain this properly: I'm hoping this can be done in just 1 long SQL statement. We have several queries that gather counts from different tables. Each takes a while and since they are part ... art (172)

CLOB #3 11 40 (11/4/2009 10:23:22 PM) comp.databases.oracle.server This may be a dumb question, but why can't Oracle read anything greater than 32767?? Even CLOB's? You really have to loop and do some crappy stuff?? ... art (172)

Queries Per Second 5 45 (11/9/2009 4:13:26 PM) comp.databases.oracle.server I'm looking over OTN & Metalink. We're looking for a way to see if we can capture how many queries per second are submitted to Oracle. Whether or not the get a cache hit is not important, just the number per... art (172)

Oracle Shell Script 6 75 (7/20/2010 4:49:07 AM) comp.databases.oracle.server I know how to use a shell variable in a query from shell. Can anyone help? This works fine ---------------------- data_rec=`sqlplus -s $user/${password} << "EOF" set heading off feedback off verify off timi... art (172)

CLOB Anyone? 12 45 (8/26/2010 9:23:23 PM) comp.databases.oracle.server Om, I'm bleeping upset as I've been at this for 3 days and been all over the net with nothing. Maybe a genius from here can help. We are on 10g. Task: Update a CLOB column. Actually replace the value, not ... art (172)

Subquery 4 41 (4/13/2011 1:52:25 AM) comp.databases.oracle.server Hi, I have this query / subquery that is acting strange. I am trying to get the latest status of a customers Trial subscription and Paid subscription. The customer may have 1, both or neither. But, in the ca... art (172)

Query question #6 6 42 (8/30/2011 5:57:31 PM) comp.databases.oracle.server Hi, We have a massive query. But there is a problem. One of the subqueries does not return any rows, therefore the entire query returns no rows. I need to make it is one of the subqueries has no results, th... art (172)

Nested Table Query 8 30 (9/11/2012 2:08:59 PM) comp.databases.oracle.server Hi, I'm trying to do a INSERT INTO (SELECT........ The table I am inserting into and the table I am selecting from have the exact same layout. However, both tables have nested tables within. I'm havin... art (172)

Comparing Tables 9 32 (9/21/2012 11:29:48 PM) comp.databases.oracle.server Hi, I am using this SQL to perform some simple table compares: data_rec=`sqlplus -s $user/${password} << "EOF" set heading off feedback off verify off timing off SELECT COUNT(*) FROM (SELECT... art (172)