03-12-2009
How do I load records from table to a flat file!
Hi All,
I need to load records from oracle table XYZ to a flat file say ABC.dat.
could any one tell me how do i do this in UNXI,
Regards
Ann
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have 20000 numbers present in a file in each line like
25663,
65465,
74579,
56446,
..
..
I have created a table in db with single number column in it.
create table testhari (no number(9));
I want to insert all these numbers into that table. how can i do it?
can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies
2. Shell Programming and Scripting
Hi gurus, hoping someone can help with a sed line that can do the following...
I have a flat file with about 1000 records, but in order to import into openoffice spreadsheet, I need to create a delimited file. I'd like to do 2 things with the SED command:
1- add a pipe character "|" at the end... (4 Replies)
Discussion started by: RogCor
4 Replies
3. Shell Programming and Scripting
Hi all,
I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat.
Can any tell me how to sort the file except first line in the file
For ex:
i/p
First line: DXYZ
Second line : jumy
third : cmhk
fourth : andy
Output should... (5 Replies)
Discussion started by: sudhir_barker
5 Replies
4. Shell Programming and Scripting
Hi,
I want to insert data into a table from a flat file, the file is having around 25 columns and some 10,000 records.
The columns values are seperated by a space.
Thanks (1 Reply)
Discussion started by: ss_ss
1 Replies
5. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
6. Shell Programming and Scripting
Hi all,
I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix,
Please leave ur comments and the fastest way to do so,
I need to load the table records into flat file.
Regards
Ann (4 Replies)
Discussion started by: Haque123
4 Replies
7. Shell Programming and Scripting
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies
8. Shell Programming and Scripting
I have a flat file that contains records similar to the following two lines;
1984/11/08 7 700000 123456789 2
1984/11/08 1941/05/19 7 700000 123456789 2
The 123456789 2 represents an account number, this is how I identify the duplicate record.
The ### signs represent... (4 Replies)
Discussion started by: jolney
4 Replies
9. Shell Programming and Scripting
I have to export data from table into flat file with | delimited. In the ksh file, I am adding below to do this activity.
$DBSTRING contains the sqlplus command and $SQL_STRING contains the SQL query. File is created properly with the data as per SQL command. I am getting white spaces in the... (1 Reply)
Discussion started by: mgpatil31
1 Replies
10. Shell Programming and Scripting
Hi All,
I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.
1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db... (0 Replies)
Discussion started by: express14
0 Replies
LEARN ABOUT DEBIAN
padre::help
Padre::Help(3pm) User Contributed Perl Documentation Padre::Help(3pm)
NAME
Padre::Help - Padre Help Provider API
DESCRIPTION
The "Padre::Help" class provides a base class, default implementation and API documentation for help provision support in Padre.
In order to setup a help system for a document type called "XYZ" one has to do the following: Create a module called "Padre::Help::XYZ"
that subclasses the "Padre::Help" module and override 3 methods: "help_init", "help_list" and "help_render".
In the class representing the Document ("Padre::Document::XYZ") one should override the "get_help_provider" method and return an object of
the help provide module. In our case it should contain
require Padre::Help::XYZ;
return Padre::Help::XYZ->new;
(TO DO: Maybe it should only return the name of the module)
The "help_init" method is called by the new method of "Padre::Help" once for every document of "XYZ" kind. (TO DO: maybe it should be only
once for every document type, and not once for every document of that type).
"help_list" should return a reference to an array holding the possible strings the system can provide help for.
"help_render" is called by one of the keywords, it should return the HTML to be displayed as help and another string which is the location
of the help. Usually a path to a file that will be used in the title of the window.
perl v5.14.2 2012-06-27 Padre::Help(3pm)