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 ","...
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...
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 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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.