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...

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...

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 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

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

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

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...

I have three table Table1 CountryId CountryName Table2 CityId CityName CountryId Table3 Areaid AreaName CityId CountryId I want to create cluster on it. First I create Cluster on Country and make table1 is part of cluster, then I made table part of that cluster. Then I create new cluster...

Dear All Some one have hide the drive name from Mycomputer shortcut from my computer. I can't see drive letters and 'Find shortcut'. How to get it back. PLease help Amer

I have range partition five tables, each partition points to separate and specific tablespace. I have planned to place tablespace on different disks to gain parallelism. But right now I don't have many disk so I use one IDE harddisk. The moment I implemented partitioning performace of inserts...

I want to create a table with 12 partition (for each month) then within each month's data should be categories based on a column. The column will have 5 possible values (107,108,109,110,111). I know that Composite partition is more closer solution. I have done this but my values are stored in...

I have following two tables Table1 refcode CityCode 1240 2240 1340 2340 1440 2440 Table2 CityCode1 CityCode2 Distance 2240 2340 100 2340 2440 200 I want to get output like this refcode1 RefCode2 Distance 1240 1340 100 1340...

I have column in a table named Sno. I want to update it with a new sequence number like 1, 2, 3 4,5 In short I want to get Sno for each row. My table is big containing 50000000 Please tell me the most efficient way of doing it. Regards Amer

Am I allowed to use oute-join like this Select Normalised_event_ID, A_Party_Id, B_Party_Id, Full_Path, Name from Normalised_event, tblOperator where Substr(B_Party_Id,1,length(code)) (+) = code and trim(full_path) = '107' order by Normalised_event_ID It give me error ORA--00920 Invalid Operator

I have to create a table which will contain 39 columns and 85000000. How I should set storage parameters of table. I mean block size, extents etc Please guide me. I need best performance. Regards Amer

Can I access another data base when I am working in another database. LIke Select * from dbmgt/Pass@sales.purch

I have a tab delimited text file having 70000000 rows. I want to read each row, need to do some processing like searching a record on the basis of a specific column. Then want to insert a record in a separate table. I need to do this untill end-of-text file, using PL/SQL. What is the best way of...