01-12-2012
To do that you REALLY need to understand SQL, and how it works to return resultsets.
Pro*C also supports PL/SQL, so that is a prime requisite as well.
Just knowing C and then popping some EXEC SQL statements into it is not what you want to do to make a career. SQL is a language in its own right, and Pro*C exists to support optimized SQL not the other way around.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
this is the seventh problem i'm having with samba.
for some reason, i cannot logon to the domain.
i've created user accounts... and i was able to establish a connection between
the samba server (my PDC) and my workstations by logging in as "root."
however now when i try to logon it gives... (5 Replies)
Discussion started by: xyyz
5 Replies
2. UNIX for Dummies Questions & Answers
Who in here works as an Unix administrator? I currently finishing up my BS Technical Management and im considering going into Unix base environment, if anybody is already in the field what do you recommended for a fresh meat like me, i currently studying to go for my solaris 10 certification as... (3 Replies)
Discussion started by: Gueso
3 Replies
3. UNIX for Dummies Questions & Answers
I just completed my solaris 10 certification, i also plan on learning shell scripting in depth can anyone advise what is the best way to job hunt in this field i have extensive expierience on windows networking and i am based in atlanta, ga
Any suggestions??? (0 Replies)
Discussion started by: niravx18
0 Replies
4. What is on Your Mind?
Hi all,
Just writing to know how to approach the situation. I am currently with 2+ exp in a support environment in Unix..mostly on the application side..have not done any Sysadmin work..
My interest is to move towards Unix admin or towards Storage/Networking side..But the problem is that my... (1 Reply)
Discussion started by: ranj@chn
1 Replies
5. Shell Programming and Scripting
I am new to scripting and I need some direction on which language to learn.
Can you please advice and which skill is very marketable career wise.Thanks in advance. (1 Reply)
Discussion started by: etcman
1 Replies
6. What is on Your Mind?
I am a junior unix sys admin (Tru64) I have been in this job for 9 months and I am quite worried.
When I first got the job I was delighted as I was finally in a job where I could have the chance to be a specialist in a field rather than being a general support guy (i graduated from uni and got... (5 Replies)
Discussion started by: supadid
5 Replies
7. What is on Your Mind?
First I like to say hi to all the people in this community. The reason I am here is because I am lost and looking for advice on my career path.
Here is a short history. I worked in the IT industry for about 10 yrs, sys admin, QA, and developer. During 911 I lost my job. Since then I have... (4 Replies)
Discussion started by: navy
4 Replies
8. What is on Your Mind?
Apologies if this is not the correct place to post this.
I used to have a job supporting several custom applications that ran on Unix platforms. I used shell scripting, sed, awk, and SQL, but all on a pretty basic level. I also performed non-technical tasks like helping with project management,... (4 Replies)
Discussion started by: intranslation
4 Replies
LEARN ABOUT OSX
sql::translator::parser::dbix::class
SQL::Translator::Parser::DBIx::Class(3) User Contributed Perl Documentation SQL::Translator::Parser::DBIx::Class(3)
NAME
SQL::Translator::Parser::DBIx::Class - Create a SQL::Translator schema from a DBIx::Class::Schema instance
SYNOPSIS
## Via DBIx::Class
use MyApp::Schema;
my $schema = MyApp::Schema->connect("dbi:SQLite:something.db");
$schema->create_ddl_dir();
## or
$schema->deploy();
## Standalone
use MyApp::Schema;
use SQL::Translator;
my $schema = MyApp::Schema->connect;
my $trans = SQL::Translator->new (
parser => 'SQL::Translator::Parser::DBIx::Class',
parser_args => {
package => $schema,
add_fk_index => 0,
sources => [qw/
Artist
CD
/],
},
producer => 'SQLite',
) or die SQL::Translator->error;
my $out = $trans->translate() or die $trans->error;
DESCRIPTION
This class requires SQL::Translator installed to work.
"SQL::Translator::Parser::DBIx::Class" reads a DBIx::Class schema, interrogates the columns, and stuffs it all in an $sqlt_schema object.
Its primary use is in deploying database layouts described as a set of DBIx::Class classes, to a database. To do this, see "deploy" in
DBIx::Class::Schema.
This can also be achieved by having DBIx::Class export the schema as a set of SQL files ready for import into your database, or passed to
other machines that need to have your application installed but don't have SQL::Translator installed. To do this see "create_ddl_dir" in
DBIx::Class::Schema.
PARSER OPTIONS
add_fk_index
Create an index for each foreign key. Enabled by default, as having indexed foreign key columns is normally the sensible thing to do.
sources
Arguments: @class_names
Limit the amount of parsed sources by supplying an explicit list of source names.
SEE ALSO
SQL::Translator, DBIx::Class::Schema
AUTHORS
See "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2012-08-16 SQL::Translator::Parser::DBIx::Class(3)