Search results for query: *

I have package: CREATE OR REPLACE PACKAGE UPD_FUNCTION_STATUS AS TYPE tJacketID is TABLE of NUMBER(10) INDEX BY BINARY_INTEGER; PROCEDURE UPD_OPEN_WAIT (JacketID IN tJacketID ); END; How can I execute this package from sql*plus? I tryed to set: var JacketID TABLE of NUMBER(10) INDEX BY...

How can I use codabar? Do i need additional functions for that? I have it in fonts and when I format fiels with codabar, all order_id look the same. Please help.Thanks.

I can't figure out why I have this error. I have two picture boxes. One picData as a frame for another picData2 where I load controls in run time. Private Sub picData_Resize() Dim sngHeight As Single ' Initializations sngHeight = 0 scbVert.Visible = (picData2.Height > ScaleHeight)...

in first case, it is false in second, it is true.

I have text box with mltLine=true. The problem is if user put "enter" in this box it triggers the command button click event. How cam I void it? Thanks.

I have small procedure, Private Sub picData_Resize() Dim sngHeight As Single sngHeight = Me.txtName(0).Height * Me.txtName.Count + 100 scbVert.Visible = sngHeight > ScaleHeight .... some code End Sub scbVert is flat scroll bar. It's never getting Visible even when sngHeight >...

I have three input parameters and record selection formula looked like this: {ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and {ORDER_PROC_V.SHIP_DATE} >= {?FromDate} and {ORDER_PROC_V.SHIP_DATE} < DateAdd("d", 1, {?ToDate}) It worked fine until I inserted control structure and changed formula on...

I use selection formula from VB. {ORDER_PROC_V.SHIP_DATE} in Date (2004, 8, 5) to Date (2004, 8, 5) . How can I modify this formula if I need report just for one single day:{ORDER_PROC_V.SHIP_DATE}=Date (2004, 8, 5) Thanks.

I need in one SQL count by two different group: by order_id from ORDERS table and item_id from order_items. I have the folloing SQL: SELECT O.ACCOUNT_ID, O.SHIP_DATE, count(O.ORDER_ID) , COUNT(I.ITEM_ID) over (partition by COUNT(O.ORDER_ID) ) LINE_ITEMS FROM orders o, order_items i WHERE...

Did you notice tr_number always different, it just breaks grouping. I have 0 in "STATUS NULL" and 1 in "STATUS V".

It gives me all orders, I need orders with at least one V status. And it doesn't give me sum.

I have order_id status tr_number 123 null 99991 123 null 99992 123 V 99993 128 null 99994 128 V 99995 130 null 99996 130 null 99997 And I need to select orders which have at least one status "V" , and how many such...

Tables, Views are checked. It's not a reason.

When I connect to Database I see just PUBLIC and SYS users. What settings I have to change? Thanks.

in dba_db_links: OWNER DB_LINK USERNAME HOST CREATED PUBLIC COM_PROD prod 11-OCT-04

We have two databases, dev and prod. I created publik link on dev, COM_PROD. Still when i use desc myTable@COM_PROD, it gives description of myTable on development server. What could be wrong? Thanks.

In table we have order_id (number) and ship_status (varchar2(1)). I'm trying to create Unique as order_id and status. If status null the same order_id can be in table a few times, but if status 'V' it should be unique. Can I do that thru oracle. Thanks.

select DATE_LAST_USED from inventory where item_code='125-325'; i have: DATE_LAST --------- 12-AUG-04

We have two servers: development and production. I run this sql: select DATE_LAST_USED from inventory where item_code='125-325' and DATE_LAST_USED <=TO_DATE('07081997','mmddyyyy') ; on development i have: no row selected, and on production I have: DATE_LAST --------- 02-AUG-04 What could...

could you give me example using this constraint. What I have to specify in Jacket_object_id field? Thanks.