- Hubs »
- tagged plsql
1-10 of 20 Hubssort by Hot Best Latest
95More 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,...
77 comments
90Mastering Oracle SQL Date Arithmetic
Describes the interpretation of arithmetic computations in Oracle PL/SQL.
17 comments
83Analytic Functions in Oracle (10g)
An easy approach and quick start to Oracle Analytic Functions.
9 comments
78Practice 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; ...
6 comments
79Oracle 10g Interview Tips and Questions
Frequently Asked Question in Oracle by Interviewers and some time by beginners.
4 comments
7876Over come the 255 Character Limit of DBMS_OUTPUT.PUT_LINE
Overcome 255 char limit with Oracle DBMS_OUTPUT (DBMS_OUTPUT.PUT_LINE)
2 comments
70How 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
64Oracle9i Development by Example
While this book is intended more for the beginner, there are many tips and techniques that even intermediate developers will find of interest, such as how to use the flashback query features, tips, and...
0 comments63sql pl/sql USE AND NEED OF PACKAGES WITH PRIVATE FUNCTIONS
SOMETIMES WE NEED TO DEFINE FUNCTIONS ACCESSIBLE TO US ONLY AND FOR THAT PROCEDURE WITHIN THE PACKAGE ONLY. PACKAGES WITH PRIVATE FUNCTIONS ARE USED FOR THE SAME TO PROVIDE INCREASED SECURITY.
0 comments
