Search results for query: *

I am working in very important sector in Canada and using Oracle widely. There is a group of experienced managers and developer who discourage to use inline views. They have some reasons in addition to (may be misleading) information pass on by Oracle. According to them Inline views are “devils...

It gives me error like ---- Server: Msg 4832, Level 16, State 1, Line 1 Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. When I chnage \n with \n\r the it then it appears Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 1...

I want to Load a text file in a three column Table with three fields, all comma separated like:- 923335100025,Amer,Baig 923335100017,Asif,Qazi 923335100089,Maz 923335120084,Tahir,Ch 923335120085,Waseem My format file is 7.0 3 1 SQLCHAR 0 20 ",&quot...

Output sould be Result 1 Customer Order_Amount Riz 100 Tiz 400 Result 2 Customer Order_Amount Biz 200 Ciz 300 I need both output as one output.

I have a table with two columns CustomerId ---- Varchar Order_Amount ----- Integer Now data is Customer Order_Amount Riz 100 Biz 200 Ciz 300 Tiz 400 Hiz 500 Uiz 600 I want...

Dis somebody install OPS on Win2K? Please help Amer

Please explain the procedure and process. I will be obliged. Regards, Amer

I have two machines running on Win2K with Oracle 8.1.7 I want to do such a arrangments that my two databases running on both machines seems one to me. I am most concerned with space. I want to use one of the machine with 200GB free space. Is it possible to create one table space in which the...

1. I have text file of atleast 4 million records. 2. I want to export it into a Table (Tab1) using SQL Loader. I may chose other option. 3. During export the duplicate records should not be populated into Tab1. 4. Duplicate Records should be populated in Tab2 for re-checking. How to achive...

I have come to know that this is known limit. See following link See this article: http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q191006 Regards, Amer

I am adding 200000 rows in MS Flex Grid. It give me memory error. Is this max limit of Grid? Please advice Amer

I am logging to a Server using Terminal Services. Can I prevent some user based on IP. I also want to get a log of all users logged in to server. Please help me Regards, Amer

It gives me error Invalid procedure Call or argument COde I run is Combo1 = Combo1.List(40000) Combo1 = GetComboItem(Combo1, 40000) Regards Amer

Any work-around?

Dear All I am using combobox in VB and putting 33000 in index. It is not allowing me. It looks that I crossed the limit of integer. How to solve it? cmbName.List(33000) = "test" Please help

Yes -- It did Thanks for great help Amer

A table comprises 30 million rows. I want to retrive only first 100 rows of it. This will help me to just see the values in table. Can I do so without where clause? Amer

Yes, this is not working in Oracle 8.0.5 but working in 8.1.7 So whats solution in Oracle 8.0.5 Amer

Error confronted -- ERROR at line 7: ORA-00907: missing right parenthesis If I remove order by then it runs fine. But I need to have order by. What to do? Amer

My query returns 4 records, with one column is datetime. I want to get first record from the set of records. Query is ============ Query ============== select Last_Modified, Service_Name, Service_Type_ID, Service_Subtype, Service_Status_Code, Active_Date from service_history where to_date...