12-01-2008
We do not allow classwork posting here.
However without giving a direct answer you should be able to get an answer by perusing the correct syntax for the if/elif/else control statement in the man page for your shell.
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a script which gives the output of schemas in Oracle DB :
#!/bin/ksh
ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL
do
if ; then
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:.
... (0 Replies)
Discussion started by: run_time_error
0 Replies
2. Shell Programming and Scripting
Hi,
I need my script to accept a column name and give all the tables and its schema.
Any kind of help is appreciated...
Thanks in advance... (2 Replies)
Discussion started by: bankimmehta
2 Replies
3. UNIX and Linux Applications
Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue (0 Replies)
Discussion started by: girija
0 Replies
4. Emergency UNIX and Linux Support
Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue..
I need it asap thats y posted here
Thanks (5 Replies)
Discussion started by: girija
5 Replies
5. Cybersecurity
Hi guys,
we are implementing new ldap in our organization exclusively for Linux authentication purposes. As we are new to the subject, I would appreciate help regarding which schema to use to create group of users and accounts / passwords entries? I see both schemas listed in subject above... (0 Replies)
Discussion started by: Lastminute
0 Replies
6. Shell Programming and Scripting
In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one.
But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.
Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies
LEARN ABOUT DEBIAN
dbicx::testdatabase
DBICx::TestDatabase(3pm) User Contributed Perl Documentation DBICx::TestDatabase(3pm)
NAME
DBICx::TestDatabase - create a temporary database from a DBIx::Class::Schema
SYNOPSIS
Given a DBIx::Class::Schema at "MyApp::Schema", create a test database like this:
use DBICx::TestDatabase;
my $schema = DBICx::TestDatabase->new('MyApp::Schema');
Then you can use $schema normally:
$schema->resultset('Blah')->create({ blah => '123' });
When your program exits, the temporary database will go away.
DESCRIPTION
This module creates a temporary SQLite database, deploys your DBIC schema, and then connects to it. This lets you easily test your DBIC
schema. Since you have a fresh database for every test, you don't have to worry about cleaning up after your tests, ordering of tests
affecting failure, etc.
METHODS
new($schema)
Loads $schema and returns a connection to it.
connect
Alias for new.
ENVIRONMENT
You can control the behavior of this module at runtime by setting environment variables.
DBIC_KEEP_TEST
If this variable is true, then the test database will not be deleted at "END" time. Instead, a message containing the paths of the test
databases will be printed.
This is good if you want to look at the database your test generated, for debugging.
(Note that the database will never exist on disk if you don't set this to a true value.)
AUTHOR
Jonathan Rockway "<jrockway@cpan.org>"
LICENSE
Copyright (c) 2007 Jonathan Rockway.
This program is free software. You may use, modify, and redistribute it under the same terms as Perl itself.
perl v5.10.1 2010-12-15 DBICx::TestDatabase(3pm)