09-11-2018
Hi,
the SQL*Loader-tool is designed to do that, no script needed. You do not say what database version you use, so I'll point you to the 10g documentation for loading XML-files into tables:
29 Loading XML Data Using SQL*Loader
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
3. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
5. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
6. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
7. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
8. 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
9. Shell Programming and Scripting
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
Discussion started by: LucyYani
2 Replies
10. Shell Programming and Scripting
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
LEARN ABOUT DEBIAN
class::loader
Class::Loader(3pm) User Contributed Perl Documentation Class::Loader(3pm)
NAME
Class::Loader - Load modules and create objects on demand.
VERSION
$Revision: 2.2 $
$Date: 2001/07/18 20:21:39 $
SYNOPSIS
package Web::Server;
use Class::Loader;
@ISA = qw(Class::Loader);
$self->_load( 'Content_Handler', {
Module => "Filter::URL",
Constructor => "new",
Args => [ ],
}
);
DESCRIPTION
Certain applications like to defer the decision to use a particular module till runtime. This is possible in perl, and is a useful trick in
situations where the type of data is not known at compile time and the application doesn't wish to pre-compile modules to handle all types
of data it can work with. Loading modules at runtime can also provide flexible interfaces for perl modules. Modules can let the programmer
decide what modules will be used by it instead of hard-coding their names.
Class::Loader is an inheritable class that provides a method, _load(), to load a module from disk and construct an object by calling its
constructor. It also provides a way to map modules names and associated metadata with symbolic names that can be used in place of module
names at _load().
METHODS
new()
A basic constructor. You can use this to create an object of Class::Loader, in case you don't want to inherit Class::Loader.
_load()
_load() loads a module and calls its constructor. It returns the newly constructed object on success or a non-true value on failure.
The first argument can be the name of the key in which the returned object is stored. This argument is optional. The second (or the
first) argument is a hash which can take the following keys:
Module
This is name of the class to load. (It is not the module's filename.)
Name
Symbolic name of the module defined with _storemap(). Either one of Module or Name keys must be present in a call to _load().
Constructor
Name of the Module constructor. Defaults to "new".
Args
A reference to the list of arguments for the constructor. _load() calls the constructor with this list. If no Args are present,
_load() will call the constructor without any arguments.
CPAN
If the Module is not installed on the local system, _load() can fetch & install it from CPAN provided the CPAN key is present. This
functionality assumes availability of a pre-configured CPAN shell.
_storemap()
Class::Loader maintains a class table that maps symbolic names to parameters accepted by _load(). It takes a hash as argument whose
keys are symbolic names and value are hash references that contain a set of _load() arguments. Here's an example:
$self->_storemap ( "URL" => { Module => "Filter::URL",
Constructor => "foo",
Args => [qw(bar baz)],
}
);
# time passes...
$self->{handler} = $self->_load ( Name => 'URL' );
_retrmap()
_retrmap() returns the entire map stored with Class::Loader. Class::Loader maintains separate maps for different classes, and
_retrmap() returns the map valid in the caller class.
SEE ALSO
AnyLoader(3)
AUTHOR
Vipul Ved Prakash, <mail@vipul.net>
LICENSE
Copyright (c) 2001, Vipul Ved Prakash. All rights reserved. This code is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
perl v5.10.1 2005-04-27 Class::Loader(3pm)