Oracle database

DB Geek says: Twitter Weekly Updates for 2009-12-20: <!– google_ad_client = "pub-4372398370642959"; /* 468×60, cre… http://bit.ly/8bjgAy # Blogged "Oracle Tampa Extreme Performance Seminar – Exadata v2" http://it.toolbox.com/trd/46/2/36029/3 # The hardest arithmetic to master is that which enables us to count our blessings. Eric Hoffer # RT: @ TheOnion Feds Uncover Secret Santa Ring http://bit.ly/8EMCxI # Fill this season with cheer by designating a sober driver before going to holiday parties! http://buzzeddriving.adcouncil.org # buzzeddriving # Blog Comments: Comment on Ora_Tweet – Tweet From Oracle, A PL/SQL Twitter API by Caramoan: Twitter in some ways i… http://bit.ly/8u5CZo # Blogged "2009 : The Oracle Year in Review ... Read Full Story

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle’s version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. - Takes an example-based approach, with clear and authoritative explanations - Introduces both SQL and the query ... Read Full Story

I'm running Oracle 8.1.7 on Windows 2000 Server. I need to write one PLSQL procedure to housekeep a table, on daily basis. There are 2 methods i can think of: 1. Use DBMS_SQL ............... stmt_char := 'DELETE FROM TABLE_A WHERE TRUNC(DT) <= TRUNC(SYSDATE) - 3'; -- always keep 3 days ................ ................ 2. Use cursor ............. CURSOR lv_delete_cur IS SELECT column_A FROM TABLE_A -- where column_A is primary key WHERE TRUNC(dt) <= TRUNC(SYSDATE) - 3; ............. ............. .............. My questions are: (a) Between approach 1 and 2, which is faster/better performance? (b) In terms of performance, is there any difference if i modify to ... Read Full Story

What is PL/SQL tables. When and why they are used. PL/Sql table is a virtual array(single array) table defined during runtime.These tables help u in storing,manipulating in a blocks thus removing the need to connect to the database for information except for the first time and later can be updated into the database. eg Assume I have a table emp emp ------ empno empname empsal saldate empcomm Now I would like to give the employees an increment/commission and will create a procedure with some logic. Create procedure empinc as type v_empsal is table of emp%rowtype; cursor as my_empsal is select * from emp where ... Read Full Story

I have written a trigger whose PL/SQL block contains a simple select statment among many other statements. Now I find that, if the select statement returns no rows the trigger does not continue its operation further and aborts there itself. And if the select statement returns some rows, then it works fine. I tried to execute a simplified PL/SQL block of the trigger in SQL*Plus and following were the results: ************************ declare tempdate date; begin select trdt into tempdate from inv_trans; if sql%notfound then null; end if; end; / ************************ When no data is present in inv_trans table, the result was: ************************ declare * ... Read Full Story