| to insert data into a particular posistion that has missed [message #234461] |
Tue, 01 May 2007 12:28  |
pravin9
Messages: 42
Registered: May 2007
|
Member |
|
|
Hi,
1.while inserting data into temp table using sql loader if one record has missed out how could i insert it into the posistion i require(i.e if 4th record has missed i need to insert it into 4th posistion) how do i do it
2.if i need to insert data in which one coloumn has , as part of data and that coloumn may have one or more multiple , how do i upload such data and the fact file is , seperated file
could u people help me out with this
thanks for ur time in advance
|
|
|
|
|
|
|
|
| Re: to insert data into a particular posistion that has missed [message #234521 is a reply to message #234467] |
Wed, 02 May 2007 00:21  |
pravin9
Messages: 42
Registered: May 2007
|
Member |
|
|
Hi,
1.While uploading data from flatfile to target table using sql loader
flat file:
ename sal job deptno
praveen 1500 analyst 40
pradeep 2500 manager 30
keerthi 4800 manager 30
shiva 1800 analyst 40
suma 2000 programmer 20
while inserting 4th record shiva has missed out and its been discarded now i want to insert that record exactly in 4th posistion can i do that
If there is no index or sequence on that table how could i do it
If there exists a sequence how do i do it
2.My flat file looks this way
empno ename sal job
1467 swetha 10,000,500 manager
1356 anil 1,00,000,000 manager
this flat file is a , seperated file how do i upload the sal col
because this col could contain one or more commas with in it
could u people help me out regarding this
thanks for ur time in advance
|
|
|
|
| Re: to insert data into a particular posistion that has missed [message #234529 is a reply to message #234521] |
Wed, 02 May 2007 01:01 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Fix Shiva's record so that it won't be discarded any more. Or, alternatively, modify table description (column datatype, length, constraints, ...) so that this record gets inserted.
Once again: there is NO 4th position. Order of records is achieved only by ORDER BY clause.
You could, however, add a sequence number (if you could) to the flat file so that it would look like 1 praveen
2 pradeep
3 keerthi
4 shiva
5 suma
Your second file isn't comma separated - the only comma(s) I see are those in the SAL column. So, either you didn't post real sample file or there's no problem at all.
|
|
|
|
| Re: to insert data into a particular posistion that has missed [message #234534 is a reply to message #234529] |
Wed, 02 May 2007 01:13 |
pravin9
Messages: 42
Registered: May 2007
|
Member |
|
|
hi,
My flat file looks this way
102,praveen,system,10,100,999
103,alex,manager,99,444,666
here my problem is that i need to upload data and the number of commas for the fourth col is not specified it might have one two or three or so
could u help me out regarding this
|
|
|
|
|
|
| Re: to insert data into a particular posistion that has missed [message #234553 is a reply to message #234549] |
Wed, 02 May 2007 02:27 |
pravin9
Messages: 42
Registered: May 2007
|
Member |
|
|
Hi,
Seems i did not explain my problem exactly as i am new to this field i had some doubts
i want to upload a file which has , as a part of the field
eno ename sal
101,praveen,kumar,naidu 5000
i want the target file to be uploaded with ename as praveenkumarnaidu
or
praveen,kumar,naidu
i would like to know if there is a solution for both the outputs
could u help me with a detailed description as to how my ctl file should look for this
thanks for ur time in advance
|
|
|
|
|
|
| Re: to insert data into a particular posistion that has missed [message #234618 is a reply to message #234549] |
Wed, 02 May 2007 13:00 |
pravin9
Messages: 42
Registered: May 2007
|
Member |
|
|
Hi
My flat file consists of large amount of data
sample flat file:
empno ename job
102,praveen,kumar,naidu,manager
104,keerthi,laxman,analyst
where do i need to specify '' so that it can treat the whole field as a single coloumn
as the flat file doesnt have 'praveen,kumar,naidu'and it is not possible to do it manually
can i specify it in the control file
can u provide me with a sample control file as to how i do it
|
|
|
|
|
|
| Re: to insert data into a particular posistion that has missed [message #234622 is a reply to message #234618] |
Wed, 02 May 2007 13:09 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If I give you this file:
empno ename job
102,michel,cadot,directeur,general
104,jean,marcel,louis,consultant
10,100,charlotte,corday,meurtriere
I said you, fields are separated by ','
Can you give me for each line:
- empno
- ename
- job
Just answer this question, with just what I gave.
Regards
Michel
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| to display data in a report based on the number of records [message #234710 is a reply to message #234621] |
Thu, 03 May 2007 00:36 |
pravin9
Messages: 42
Registered: May 2007
|
Member |
|
|
Hi,
1.i wanted to display data in a report which has this condition
if i have 5 records or less i need to display it in the first page.
otherwise i need to display the first page blank and start displaying from second page
2.how do i display running total for a report
thanks for ur time in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
