11-26-2012
On an early version of a utility CIS in oracle 6, we had to have separate schemas - One for Spanish, another for English. There too many side effects otherwise.
We published two data dictionaries one for Spanish, one for English, to a special set of tables we used for prompting. We did not use comments. We used two sets of synonyms that had descriptive table and field names. Base sql code was unaffected by this.
I am sure this is not what you wanted to hear.
8 More Discussions You Might Find Interesting
1. Solaris
dear solaris group,
whitch are the best book for study admin 1 + 2 on solaris 9
to prepare for the exam of admin 1 & 2
best regards
Maurizio (2 Replies)
Discussion started by: mauric
2 Replies
2. UNIX for Advanced & Expert Users
how good are nextcertify.com preps for veritas exams ? .
i look forward to yoiur responses (1 Reply)
Discussion started by: rendu
1 Replies
3. Linux
Hi all,
Could someony give me a link to download a document for preparing linux RHCE certification?
Regards,
Tovo (0 Replies)
Discussion started by: tovohery
0 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
Not sure if this would be in a dummies sectiin or advanced. I'm looking for a script if someone has doen something like this.
I have list of files -
adc_earnedpoints.20070630.txt
adc_earnedpoints.20070707.txt
adc_earnedpoints.20070714.txt
adc_earnedpoints.20070721.txt... (2 Replies)
Discussion started by: thebeginer
2 Replies
5. UNIX for Dummies Questions & Answers
I had install Sun Solaris 10 in my virtual machine. Anyhow I still very limitation knowledge how to operate it. Would like to search for help somemore could assist me how could I get the resources by free for me to learn and prepare myself for sitting the Sun cerfitication exam?
Please help and... (3 Replies)
Discussion started by: jimmyysk
3 Replies
6. AIX
Guy's
AIX Monitoring Tool - under preparing .....
I'm working to make and prepare tool to monitor AIX system and my idea it's based on the following outputs
I want command to give me shout outpous about the following ...
CPU load
Memory load
Used load
Number of... (5 Replies)
Discussion started by: Mr.AIX
5 Replies
7. Shell Programming and Scripting
Hi All
I'm currently trying to develop a script which will find the child processes of a process ID already passed to the script.
I then need the script to look for spawned processes of these child processes and so on until it can't find any more.
For example
At the moment, I have to... (6 Replies)
Discussion started by: huskie69
6 Replies
8. Shell Programming and Scripting
I have a Perl package, which is widely used and tested, but recently a version in another language was added. The relevant po-files have been reviewed for this and are ready for testing. What are the steps to select the language by the user? From my understanding the language environment variable... (3 Replies)
Discussion started by: figaro
3 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::view
SQL::Translator::Schema::View(3pm) User Contributed Perl Documentation SQL::Translator::Schema::View(3pm)
NAME
SQL::Translator::Schema::View - SQL::Translator view object
SYNOPSIS
use SQL::Translator::Schema::View;
my $view = SQL::Translator::Schema::View->new(
name => 'foo', # name, required
sql => 'select id, name from foo', # SQL for view
fields => 'id, name', # field names in view
);
DESCRIPTION
"SQL::Translator::Schema::View" is the view object.
METHODS
new
Object constructor.
my $view = SQL::Translator::Schema::View->new;
fields
Gets and set the fields the constraint is on. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
field names and keep them in order by the first occurrence of a field name.
$view->fields('id');
$view->fields('id', 'name');
$view->fields( 'id, name' );
$view->fields( [ 'id', 'name' ] );
$view->fields( qw[ id name ] );
my @fields = $view->fields;
tables
Gets and set the tables the SELECT mentions. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
table names and keep them in order by the first occurrence of a field name.
$view->tables('foo');
$view->tables('foo', 'bar');
$view->tables( 'foo, bar' );
$view->tables( [ 'foo', 'bar' ] );
$view->tables( qw[ foo bar ] );
my @tables = $view->tables;
options
Gets and sets a list of options on the view.
$view->options('ALGORITHM=UNDEFINED');
my @options = $view->options;
is_valid
Determine whether the view is valid or not.
my $ok = $view->is_valid;
name
Get or set the view's name.
my $name = $view->name('foo');
order
Get or set the view's order.
my $order = $view->order(3);
sql
Get or set the view's SQL.
my $sql = $view->sql('select * from foo');
schema
Get or set the view's schema object.
$view->schema( $schema );
my $schema = $view->schema;
equals
Determines if this view is the same as another
my $isIdentical = $view1->equals( $view2 );
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
perl v5.14.2 2012-05-01 SQL::Translator::Schema::View(3pm)