1-10 of 12 hubssort by Hot Best Latest
85Mastering Oracle Date Arithmetic
Date Arithmetic is the calculations based on date. Doing Date calculations is a night mare many times for a developer, especially in Oracle many developer felt this. But many of us never knew simple tricks...
11 comments
89More 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...
25 comments
81Oracle Analytic Functions
Oracle Analytic Functions Analyctic functions in Oracle are set of functions and clauses used for arriving statistical informations like sum, average. These functions are more flexible to use and efficient....
1 comment
76Oracle Exceptions
Exceptions in Oracle are powerful error handling mechanism. Do you feel little difficulty hearing the word Exception handling? This page depicts Exception handling and gives you very clear understanding of...
0 comments
68Practice 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); ...
0 comments
83Over come the 255 Character Limit of DBMS_OUTPUT
Oralce has provided the DBMS_OUTPUT package for the PL/SQL Developers. PUT_LINE function is probably the most used feature of Oracle Developers. PUT_LINE is used for displaying the results/outputs in the...
2 comments
60Base de Dados
_____________________ -------------------------------- CREATE PACKAGE BODY emp_data AS PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp, choice INT) IS BEGIN IF choice = 1 THEN OPEN emp_cv FOR SELECT *...
0 comments
58Oracle SQL Developer
Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL...
0 comments73Oracle Interview Tips and Quetions
Oracle is strong in database management and data-warehousing for more than decades. It is leading the RDBMS world on top rank. Being a Oracle techie, one has lots of opportunities. We posted our first...
1 comment
46Oracle PL/SQL Programming
Preface Thousands of application developers and database administrators around the world use software provided by Oracle Corporation to build complex systems that manage vast quantities of data. At the...
0 comments
