1-10 of 22 Hubssort by Hot Best Latest
89Oracle 10g Interview Tips and Questions
Frequently Asked Question in Oracle by Interviewers and some time by beginners.
4 comments
68How to convert between DBMS_SQL and Native Dynamic SQL in Oracle 11g
This Article is intended for plsql programmer, who may not be aware of the new features of Oracle 11g.One of those new features is to switch between dynamic SQL and DBMS_SQL. You may asking why to switch to DBMS_SQL while native dynamic SQL(NDS) is...
0 comments
87Mastering Oracle SQL Date Arithmetic
Describes the interpretation of arithmetic computations in Oracle PL/SQL.
16 comments
88More Oracle Interview Questions : SQL and PL/SQL
I can say Oracle database is a box of chocolates. You never know what you're gonna get. The more I learn about it, the more there is to learn. It's getting so much better with each new release too. See what Oracle 10g has to give us.. recycle bin,...
64 comments
79Oracle Exceptions (handling value error and other common errors)
An insight to Oracle Exceptions.
1 comment
86Oracle Analytic Functions (10g)
An easy approach and quick start to Oracle Analytic Functions.
9 comments
77Practice PL/SQL Examples - Part 1
DECLARE PROCEDURE print_number( n1 NUMBER) IS tot NUMBER := n1 ; BEGIN FOR i IN 1 .. 10 LOOP dbms_output.put_line(tot); tot := tot + 1; ...
3 comments81Over come the 255 Character Limit (length overflow)of DBMS_OUTPUT.PUT_LINE
Overcome 255 char limit with Oracle DBMS_OUTPUT (DBMS_OUTPUT.PUT_LINE)
2 comments
60Oracle Exceptions - User Defined and Oracle Defined
http://forums.oraclepassport.com 1. What are exceptions in Oracle? Exceptions are the ways in which Oracle could handle runtime errors in a PL/SQL block. Exceptions are always useful to debug the code as...
61How to Optimize Database Code
I believe that you are not among the people who think money is for free. The reason for saying this is because you are probably aware that financial costs are much higher if your source code is already...
0 comments
