Oracle Help
in [SQL]
|
huge returned number problems hi all, i want to Show total purchases by supplier in 2006. and i want to nclude only those suppliers from whom we made purchases of more than 2,000,000 during the first 6 months of 2006. so i did the following: select purpmt.suppl_code as "Supplier", sum(purch.qty * purch.unit_price) "Total Purchases" from pur... 15 Jan 2008 12:14
where cluase help please hi all. i want to Produce total sales per month per indicated region. The total should include only sales of products with more than 4,000,000 total sales. i did the following but it is giving me huge number: somebody please tell me why? SELECT TO_CHAR(purinv.Inv_Date,'mm') || ' - ' || TO_CHAR(purinv.Inv_... 15 Jan 2008 09:59
Poll: How fast is YOUR database in rows per second, on a full bore table scan??? Some observations: - same machine, using RH ES 5 (CentOS 5.1+updates), with LVM/stripe set does not make a difference in timing (differences are too small to measure...) - playing around with the LIMIT clause actually *does* make a difference; from 1000 to 500: none from 1000 to 100: -10% (.30 secs to ... 15 Jan 2008 08:50
Multi column update based on another table Hi Folks, I'm writing a simple update statement in Ora 9.2 and am scratching my head as to why the following syntax is wrong: ------------------------------------------------------------------------------------------------------------ update CITI_CIRCUIT_LBCODE A Set (LOOPBACK_ADDR_A, HOST_NAME_A ) = (SELECT ... 15 Jan 2008 11:07
leaf nodes from a tree choice hi all, i need to produce a report which shows the sum last down level employees and only those i ve done an attempt which i am posting, but it is giving me weird results(my fault), it is giving me roots also as wel as nodes, something is missed from my querie but i dont know what should it be, to tell sql to go ... 22 Jan 2008 16:16
Help S.O.S: How to return resultset from procedure and use it on c# Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is written. When i want to call procedure from c#, i'm confused to send parameter. Wichc typed parameter is sent from c# or how to solve this mess. --This is my types packa... 14 Jan 2008 07:15
Composite index question Hi, I have a question on how composite index should be used. As an example, my queries often select two leading columns, column_1 and column_2 of a table. Should I create a composite index using column_1 and column_2, or should I create two separated indexes for column_1 and column_2? What are the differences... 14 Jan 2008 00:30
Installation of Oracle with unixODBC Hi, at least since Oracle 10.2.0 the Oracle Linux distribution contains an ODBC driver which works with unixODBC. After installation of the Oracle Enterprise Edition, the driver can be found at $ORACLE_HOME/lib/libsqora.so.10.1 Simply using this library in odbcinst.ini (Driver = ) made ODBC work on my Suse ... 13 Jan 2008 18:58
how to get specific values from multi-table function hi all, i am posting a sample of a result i am getting from the following formula ------------------------------------------------------------------------------------------------------ select (to_char(salinv_1.inv_date, 'MM'))as "MM", (to_char(salinv_1.inv_date, 'YY')) as "YY", (sales_1.prod_code) as "Code", sum... 13 Jan 2008 12:19
recursive formula help please! hi all, i have a sales table that i want to get the balance for some specific condition products, i am getting the wrong balance since i lack the knowledge of how to do a recursive formula, you may know that the balance of FEB for instance depends on JAN so on and so forth so my best attempt to solve the problem w... 12 Jan 2008 19:19 |