04-17-2007
Thanks again, Radoulov.
I know C, C++, Java, Oracle SQL/PL-SQL very well.
But I would like to continue in the field of UNIX development (not in admin) also I like to build my career in this technology. But Iam in totally confusion about my next steps. I dont know what to do.
Is there any opening in Italy for my profile. (Also I like Italy very much).
Currently Iam working for one small Software firm in India.
Thanks for your light.
With Regards,
Ganapati.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
My question is: difference between unix and linux in terms of compiler, file system, ANSI
compliance, standard liabrary issues, threading issues, operating system
calls memory issues..ie whether these things wud cause problems while
porting a unix programme to linux.?
I think answer is depend... (1 Reply)
Discussion started by: prasoon
1 Replies
2. Shell Programming and Scripting
please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
My name is vreddy and I am learning c language now and written one programme on vi editor.
how do I compile the programme please give me some advice and that would be helpfull for me.
thanks
vre (10 Replies)
Discussion started by: vasudeva
10 Replies
4. Programming
Hi All,
How to call the C programme in UNIX shell scripting?
please send me some sample script for the above scenario.
Regards,
MPS:b: (1 Reply)
Discussion started by: psiva_arul
1 Replies
5. UNIX for Dummies Questions & Answers
hi friends,
I would like to do the certification in Korn shell scripts { i am using HP UNIX machine }. is there any certification for UNIX shell script . If yes please tell me the details . i am junior level oracle plsql developer . i interseted in unix shell scripting . i need... (1 Reply)
Discussion started by: rdhaprakasam
1 Replies
6. Shell Programming and Scripting
Hi,
I am very new to this forum, can any one tell me which is the very basic certification on unix shell scripting?
please give me an advice on this. (1 Reply)
Discussion started by: Manjesh
1 Replies
7. Shell Programming and Scripting
Hi all,
Please let me know whether any certifications are there for Shell Scripting. (Not Brainbench). If any one know pls post the details.
Thanks in advnce.. (1 Reply)
Discussion started by: divya bandipotu
1 Replies
8. UNIX for Dummies Questions & Answers
Hello Experts,
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies
9. Shell Programming and Scripting
Requirement is :-
1. there will be daily monthly and on demad flat files coming in SourceDir folder in unix.
I want that if daily files are copied in the folder then my script shd check that if files are copied and are correct then process to load files trigger otherwise send a mail to... (1 Reply)
Discussion started by: Ruchi A
1 Replies
10. Shell Programming and Scripting
I am new to Unix..
Can someone please help me to understand the concept of Login shell and non login shell ?
what exactly the difference between them :confused: (1 Reply)
Discussion started by: lokita jain
1 Replies
LEARN ABOUT PHP
oci_parse
OCI_PARSE(3) OCI_PARSE(3)
oci_parse - Prepares an Oracle statement for execution
SYNOPSIS
resource oci_parse (resource $connection, string $sql_text)
DESCRIPTION
Prepares $sql_text using $connection and returns the statement identifier, which can be used with oci_bind_by_name(3), oci_execute(3) and
other functions.
Statement identifiers can be freed with oci_free_statement(3) or by setting the variable to NULL.
PARAMETERS
o $connection
- An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $sql_text
- The SQL or PL/SQL statement. SQL statements should not end with a semi-colon (";"). PL/SQL statements should end with a semi-
colon (";").
RETURN VALUES
Returns a statement handle on success, or FALSE on error.
EXAMPLES
Example #1
oci_parse(3) example for SQL statements
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
// Parse the statement. Note there is no final semi-colon in the SQL statement
$stid = oci_parse($conn, 'SELECT * FROM employees');
oci_execute($stid);
echo "<table border='1'>
";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo "<tr>
";
foreach ($row as $item) {
echo " <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>
";
}
echo "</tr>
";
}
echo "</table>
";
?>
Example #2
oci_parse(3) example for PL/SQL statements
<?php
/*
Before running the PHP program, create a stored procedure in
SQL*Plus or SQL Developer:
CREATE OR REPLACE PROCEDURE myproc(p1 IN NUMBER, p2 OUT NUMBER) AS
BEGIN
p2 := p1 * 2;
END;
*/
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$p1 = 8;
// When parsing PL/SQL programs, there should be a final semi-colon in the string
$stid = oci_parse($conn, 'begin myproc(:p1, :p2); end;');
oci_bind_by_name($stid, ':p1', $p1);
oci_bind_by_name($stid, ':p2', $p2, 40);
oci_execute($stid);
print "$p2
"; // prints 16
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
This function does not validate $sql_text. The only way to find out if $sql_text is a valid SQL or PL/SQL statement is to execute
it.
SEE ALSO
oci_execute(3), oci_free_statement(3).
PHP Documentation Group OCI_PARSE(3)