Category Archives: PL-SQL

PLSQL

FOR UPDATE and WHERE CURRENT OF Clause http://www.dba-oracle.com/t_adv_plsql_for_update_where_current.htm Advanced PL/SQL Programming The Definitive Reference http://www.rampant-books.com/book_1701_plsql_definitive_ref.htm#_Toc490865538 http://www.dbmanagement.info http://www.dbmanagement.info https://asktom.oracle.com/pls/asktom/f?p=100:14:::NO:RP,14:: https://asktom.oracle.com/pls/asktom/asktom.search?tag=inserts-with-append-hint Viewing Oracle Compile Errors http://razorsql.com/articles/oracle_compile_errors.html ORA-06502: PL/SQL: numeric or value error http://www.dba-oracle.com/t_ora_06502_pl_sql_numeric_value_error.htm How to trap DDL Activities and get the Sql … Continue reading

Posted in PL-SQL, PLSQL | Tagged | Leave a comment

ASSIGNMENT SHEET on RELATIONAL ALGEBRA AND SQL Queries

ASSIGNMENT SHEET on RELATIONAL ALGEBRA AND SQL Queries                                    ASSIGNMENT SHEET NO: 1 ASSIGNMENT SHEET on RELATIONAL ALGEBRA AND SQL Instructions to the students:   … Continue reading

Posted in Final year project help, oracle technology, PL-SQL, Project, Project help, SQL, SQL Assignment, SQL Most important Queries, SQL Queries, SQL Top 110 Queries | Tagged , , , , , , , , , , , , , , , , | Leave a comment

a mail from my senior (few pointers for the oracle technology)

a mail from my senior (few pointers for the oracle technology) Ashutosh, 1. For Oracle Apex – to start with go here, http://apex.oracle.com/i/index.html   and create account so that you can try it. On this very page there is getting started link. … Continue reading

Posted in oracle technology, PL-SQL, SQL | Tagged , , , , , | Leave a comment