Search results for query: *

Hi, I changed the condition to use CREATED_ON col which is the partition key rather than DOC_DT and the query didn't do a scan on all partitions. AND CREATED_ON BETWEEN ADD_MONTHS(TO_DATE(:P_YEAR,'YYYY'), -11) AND ADD_MONTHS(TO_DATE(:P_YEAR,'YYYY'), 1)-1

Hi, I have written this query for a partitioned table and what I get is that it scans all the partitions, why is this so? SELECT COUNT(trn_no) FROM TRANSACTIONS WHERE ORG_CODE = :P_ORG_CODE AND DOC_DT BETWEEN ADD_MONTHS(TO_DATE(:P_YEAR,'YYYY'), -11) AND ADD_MONTHS(TO_DATE(:P_YEAR,'YYYY'), 1)-1...

Thanx, it worked

hi, I get this error ora-000936, missing expression, when I run this insert statement: INSERT INTO MENU_USER ( MENU_ID, GROUP_ID, PI, PU, PD, CR_DTE, CR_USER_ID, UPD_DTE, UPD_USER_ID) VALUES ( SELECT MENU_ID, 'CODE2', 'Y', 'Y', 'Y', SYSDATE, 'ALEX', NULL, NULL FROM MENUS B WHERE B.MENU_ID =...

Thanks Beilstwh for clarifying that uncommitted sessions existed.

I got this error ORA-04021: timeout occurred while waiting to lock object TAB_OS after issues the create index command

Have simulated my steps on a test system but the case where no data is returned by the statement doesnt recurr. Have appended the spool: SQL> select count(A.TAB_TD_SYS_ID) 2 from TAB_OS B, 3 TAB_os A, TAB_CUR_TRANS_DETAIL G 4 where G.TD_FLEX_02 = 'value1' 5 AND G.TD_FLEX_05 = 'B'...

By "returned no data" I mean it ran n said "no rows returned

the sequence is a) ran a select on some data n it returned some data b) created the index c) ran the same select as a) and it returned no data d) dropped the index e) ran the same select as a) and it returned data

Dagon, There's no error message. I noticed there was something wrong when a Select statement I ran before adding the index didnt return any value. The Statement return values later after removing the index.

Hi, I added an extra index to a table however data inserted into the table can't be retrieved. There was already an unique index present. The index created is nonunique, could this be the reason?

I reformated a report with the result that its now faster and the message box for report's progress doesn't show the "Page break at next page" button anymore. Is there anyway it can be brought back. I have been requested by a user so that they can generate delimited files on a page by page...

Have traced the issue to a coding error and not anything related to how oracle reports does its processing. My apologies for any inconvinience.

Hi, I'm using reports 6i. I have a query with a formula column that I use to get values. The formula column has atleast 4 cursors and is used to update a place holder within the same group. [ main query ] | [ Column 1 ] [ Column 2 ] [ Placeholder1] [ formula column] [ ...

Had the same problem: thread259-1074710 I reported that it was as a result of using an older version of rpt2xls. Check ur version of rpt2xls. Got mine from http://www.geocities.com/oranails/reports/rpt2xls.htm Another thing to check is where u place ur formatting code. Avoid placing the code...

Thanks Scunningham99 , I got that recovery is not possible. Previously, I thought having all the backups of the new incarnation would suffice.

Its hard to make out what the code does. Please explain the statements batchID(DDMMYY+seqNo) + 'AB' + ... batchID(DDMMYY+seqNo+1) + 'BC' + ..... in specific what is "'AB' + ...". Are A and B tables?

Got this from http://www.techonthenet.com/sql/union_all.php The UNION ALL query allows you to combine the result sets of 2 or more "select" queries. Oracle doesnt treat the statements as separate. It doesnt make an attempt to analyse the entire UNION ALL statement before excution.

There are no WHERE clauses in the statements joined by the UNION ALL or the view PatView, so the statement does a full tablescan -- statement 1 of the where clause Select PAT_ID, PAT_MRN_ID From PatView -- [ No WHERE clause ] -- Union All Select PAT_ID...

I omitted the errors on startup.Am not sure if it answers the second question. Please rephrase it if it doesnt. Below is the omitted section: SQL> startup ORACLE instance started. Total System Global Area 126950220 bytes Fixed Size...