A community portal about Oracle database with blogs, videos, and photos. According to Wikipedia.org: An Oracle database consists of a collection of data managed by an Oracle database management system. Popular generic usage also uses the...
[more]
A community portal about Oracle database with blogs, videos, and photos. According to Wikipedia.org: An Oracle database consists of a collection of data managed by an Oracle database management system. Popular generic usage also uses the term to refer to the Oracle DBMS management software, but not necessarily to a specific database under its control.
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... 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... 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... Read Full Story
Can we use user definbed functions in SQL statements, as we can use in built oracle function like date etc..? Yeah.Of course provided there is no dml in your function Thanks for reply, pls tell you can't we use functions with DML in it. What will hapen if it conatins dml in it. We can use function which has only select statments in it, but it should not contain other DML statements like INSERT,UPDATE and DELETE oracle doesnot allow because it might get conflicts Add A Function To User Defined... Read Full Story
I've recently installed my Oracle 9i database and developers suite and I've created the repository owner and I've created my tablespaces to use in oracle 9i designer but I'm having problems granting roles to the repository owner. I can login to sqlplus.exe but I can't seem to run the 'ckrorole.sql' file which as far as I know is used to grant roles to the repository owner. I keep getting the following message whenever I try to run it. By the way, I'm using Windows XP. SQL*Plus: Release 9.2.0... Read Full Story
What is the difference between shutting down an Oracle database (8i and up) on Windows by logging into the instance and issuing the shutdown command vs stoping the Oracle service (OracleServicedbname)? I think there's no difference - but you can see many more informations by logging in with sqlplus/svrmgrl and shutting down the DB with the shutdown command. Using MMC and shutting down the service shows only a status bar. Depends on the version of Oracle and how the instance is configured in... Read Full Story
n this Blog I will explain with explain how to create ADF Pages based on the Web services. Here I will take the example of creation of web service based on PL/SQL API OE_ORDER_PUB.PROCESS_ORDER.This API is integral part of Oracle Order management. Main feature of this API is to Create Sales Order
Once ADF Page Ready, it will create Sales Order in Oracle Order Management, based on the input Parameters.
Components involves in my test case are
PL/SQL API wrapper that will call... Read Full Story
eBook Details Author:Nitin Vengurlekar, Murali Vallath, and Rich Long No of Pages: 340 pages Press: McGraw-Hill Osborne Media; Edition:1 edition Dated:November 5, 2007 Language: English ISBN-10: 0071496076 ISBN-13: 978-0071496070 eBook Description Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive... Read Full Story
In this Example I am doing Setup for iStore.
Step1:
Profile Option Setup
Select the Responsibility Application Developer and Navigate System Profile Navigate to >Profile>System
Open the profile Form and Query for User Profile Name ‘Sequential Numbering’
Sql validation Item should hav following Text
SQL=”SELECT MEANING \”Sequential Numbering\”,lookup_code
Into :visible_option_value,:profile_option_value... Read Full Story
Summary In this chapter we learned everything we need to do to get ready for our Forms to APEX conversion project. Here are the necessary steps we went through before we started We have seen what files we need. These are the.FMB Forms Modules .OLB Object Libraries .MMB Menu Modules .PLL PL SQL Libraries and RDF REX or JSP Reports files. . We have used the Fo Category: Oracle Forms Read Full Story
