Functional Design Document For Existing Package
Feb 25, 2013I would like to design a functional design document for existing package. Let me know is there any tool which will build the design document?
View 8 Replies
ADVERTISEMENT
Develop Functional Document For Existing Package
Feb 21, 2013I would like to develop a functional document for existing package. How to prepare the document if posted the whole code here?
View 1 Replies View RelatedMobile Server :: Deploy Existing Apps Design For Win Mob 6 On Windows 8 Phone
Mar 9, 2013It looks that windows mobile is gone and windows 8 is available.. Can a vb .net application developed to run on win mobile 6 with oracle lite be deployed on windows 8 phone.
View 3 Replies View RelatedPL/SQL :: Existing State Of Package Has Been Discarded
Nov 2, 2012I am getting the following error only for the ""first execution"", even the package is in "valid" state. If the execute the same package again "second execution", it runs ok.
usually we complie all the "invalid objects" in the schema when we move the code to TEST or PRE-PROD env.
but i am getting the following error, even if the package is in "valid state".
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "TEST_OWNER.TEST_PKG" has
been invalidated
ORA-04065: not executed, altered or dropped package
"TEST_OWNER.TEST_PKG"
ORA-06508: PL/SQL: could not find program unit being called:
"TEST_OWNER.TEST_PKG"
ORA-06512: at line 2I have gone through the following thread, blu explained the cause of this error,
but do we get this error even when the package is in "valid" state too?
Re: When should be package invalidated?
Client Tools :: How To Add Function To Existing Package
Nov 11, 2010I want to add my function to the existing package.
View 8 Replies View RelatedSQL & PL/SQL :: Functional Index
May 19, 2011How can i turn this into functional index.
WHERE (IPC_DISP_ID IS NOT NULL AND DISP_EXIST > 0)
AND (IPC_UPU_BCD IS NOT NULL AND RECPT_EXIST > 0)
AND ( (IPC_ITM_ID IS NOT NULL AND ITM_EXIST > 0) OR IPC_ITM_ID IS NULL )
SQL & PL/SQL :: What Is Cluster / Bitmap And Functional Index
Dec 26, 2011index types like cluster,bitmap,binary tree,functional. Specify the differences between these types
View 5 Replies View RelatedCreate Dimension - Functional Dependency Between Levels
Sep 28, 2010the literature equates dimension hierarchies with fuctional dependencies between the levels. I like to tst the strength of this assumption with the implementation of 'CREATE DIMENSION' which allows you to create roll-up hierarchies.
My question to put it simply is this: Given:
CREATE DIMENSION location_dim
LEVEL location IS (location.loc_id)
LEVEL city IS (location.city)
LEVEL state IS (location.state)
HIERARCHY geog_rollup (
location CHILD OF
city CHILD OF
state CHILD
)
Can I insert the following rows into the dimension:
loc_id, city, state
1, Epping, NSW
2, Epping, VIC
Please note that the two Eppings are different cities.
Given the roll-up hierarchy City -> State, will it require that for every city there can be only one state in which case the FD between City and State cannot hold. Or, is it that the roll-up hierarchy defined here has nothing to do with FD.
The second part of the question is if the answer to the above question is that the roll-up is not the same as FD, then is the ATTRIBUTE clause meant to define the n:1 (functional dependency) instead?
SQL & PL/SQL :: Functional Difference Between Type %rowtype And Record
May 17, 2010What is functional diffrence between type, %rowtype and record.
View 3 Replies View RelatedEnterprise Manager :: OEM 12c - Compare Period ADDM Non-functional
Apr 17, 2013In my production environment, I have a mostly working Oracle 12c Cloud Control environment, managing several database instances. On all of the databases, I am unable to use the Compare period ADDM feature ( Instance > Performance > AWR > Compare Period ADDM).
When I select that menu option, I see the message "To be able to use this feature some PL/SQL packages need to be loaded into the target database's monitoring schema, DBSNMP." I have been searching for further information in the specific packages that need to be loaded per the message, but neither Orafaq, [URL] nor Google seem to have those details.
SQL & PL/SQL :: ORA-30556 - Functional Index Is Defined On Column To Be Modified
Feb 2, 2012I'm altering a column length to increase the size and getting "ORA-30556: functional index is defined on the column to be modified".
On searching more about this error, it seems like the function index must be dropped before altering the column.The table I'm dealing with is huge.
Question 1:In case of dropping and recreating the index, should the following steps be done:
- Drop Index
- Alter the column to increase the size
- Recreate the index with NOLOGGING and NOPARALLEL clause
- ALTER INDEX to turn on LOGGING
- Gather Statistics on that index
Question 2:Is there anything else that should be done when the index is dropped and re-created?
Question 3:What are the side-effects of carrying out the above steps in a huge table with around 15 million rows?
Question 4:Would it work if I disable the index, alter the column and reenable the index?Do I have to rebuild the index and gather Stats upon reenabling it?
SQL & PL/SQL :: Existing Role Claimed To Be Not Existing?
Dec 19, 2011I'm am getting an error that says that a role doesn't exist when I can cleary see it in DBA_ROLES. I can successfully grant other roles in this session. I am using Oracle 11.1 on RAC.
GRANT "CONNECT" TO BAKERD
Error at line 1
ORA-01919: role 'CONNECT' does not exist
select * from dba_roles where role = 'CONNECT'
[code]....
SQL & PL/SQL :: Functional Index - Catch Exception And Print Customized Message
Feb 16, 2011I have a functional index.. which doesn't allow duplicate based on condition.I want to catch the exception and print the customized message but it always override my message.
create or replace function i_func
(tt_id in number,
d_date date,
stat in varchar2)
return varchar2
[code].....
output: ORA-00001: unique constraint (abb.TEST_IDX) violated
Performance Tuning :: Create Small Functional Indexes For Special Cases In Very Large Tables
Apr 5, 2012Create small functional indexes for special cases in very large tables.
When there is a column having one values in 99% records and another values that have to be search for, it is possible to create an index using null value. Index will be small and the rebuild fast.
Example
create index vh_tst_decode_ind_if1 on vh_tst_decode_ind
(decode(S,'I','I',null),style)
It is possible to do index more selective when the key is updated and there are many records to create more levels in b-tree.
create index vh_tst_decode_ind_if3 on vh_tst_decode_ind
(decode(S,'I','I',null),
decode(S,'I',style,null)
)
To access the record can by like:
SQL> select --+ index(vh_tst_decode_ind_if3)
2 style ,count(*)
3 from vh_tst_decode_ind
4 where
5 decode(S,'I','I',null)='I'
6 group by style
7 ;
[code]....
PL/SQL :: Find Out In Database Package Where Package Is Installed
May 28, 2013I need to find out in DB Package where this Package is installed (in which schema). The problem is this DB Package can be installed in various schemas. This means that I can't use select user from dual or system environment SYS_CONTEXT('USERENV', 'OS_USER').
What I would need is something like $$PLSQL_UNIT
HR Schema And Jsf Web Design?
Jul 13, 2013 how can ı reach hr schema I watched alot of video and have read so much writing from oracle but my data base haven't HR schema table like
emlployees
countries
jobs
how can ı add these hr schema
2) how can ı create web page with adf web applicaiton jsf
1) adding a search button
2) search fieldand I need to list my search results
SQL & PL/SQL :: How To Design Subprogram Which Can Generate Pk Value
Sep 15, 2011i mean which can generate a primary key when the table name and column name are passed as parameters
View 7 Replies View RelatedSQL & PL/SQL :: How To Design ERD For Rental Management
Dec 17, 2012how to design the ERD for Rental Management like I want know how to design tables to check every month's rent. Is there any way to store month and year with out day in database?
View 2 Replies View RelatedSQL & PL/SQL :: Doctors And Patients Design
Mar 9, 2013Is this true for code
•Employees(employee_id PK)
•Patients(patient_id PK, full_name, age)
•Surgeries( doctorid FK, patient_id FK, surgerydate)
doctor_id number (2) references patients(patient_id),
patient_id number (6) references patients(patient_id),
surgery_date date not null
PL/SQL :: Design Features For CSV Files
Dec 17, 2012I got a couple of reports that are made as .CSV files from PL/SQL. However I am lacking some design features. Is it possible to define text + background color and height + width of fields? (I am using utl_file package.)
View 4 Replies View RelatedPL/SQL :: Design Tables Without Primary Key?
Aug 13, 2012If you were asked to design a schema, would you create a table (however irrelevant) without a primary Key ? Say for example, a 'non-business' table like an Error logging table which logs exceptions thrown from stored procedures, would you create this table without a primary key ?
View 7 Replies View RelatedSQL & PL/SQL :: How To Design Subprogram Which Can Generate Primary Key Value
Mar 22, 2012how to design subprogram which can generate a primary key value whenever the table name and column name are passes as parameter.?
View 19 Replies View RelatedSecurity :: Oracle Audit Design?
May 28, 2011Let us say I want to audit data updates, deletes on existing table EMP_TAB that has a few hundred thousands of records.I created a shadow table Emp_tab_audit and added few audit columns
Emp_tab (
Empno NUMBER NOT NULL,
Ename VARCHAR2(10),
Job VARCHAR2(9),
[code]...
I am mostly interested in UPDATES and DELETES but I decided to add INSERTS to have full history for each eomplyee in one table (audit schema) instead of querying two tables all the time (production table and audit table) to see the changes.
I created this AFTER INSERT, UPDATE, DELETE trigger.decided to copy the :NEW values for INSERT and UPDATE and :OLD values for DELETE. attached.
so when insert happens, the first audit row is created in EMP_TAB_AUDIT. update happens, the 2nd new row is created in EMP_TAB_AUDIT.
The problem I am facing is the old records that curently exist. If someone updates an old row I am copying the :NEW values so I won't have a copy of the :OLD values unless I create 2 ROWS (one for the old and one for the new).
Do you think I should copy all the hundreds of thousands of records to the AUDIT tables for this to work.
*******************************************************************
CREATE OR REPLACE TRIGGER TRG_EMP_AUDIT
AFTER INSERT OR DELETE OR UPDATE ON EMP_TAB
FOR EACH ROW DECLARE
v_operation VARCHAR2(10) := NULL;
[code]...
What Will Be Database Design Of Any Food Shop
Mar 21, 2009i am a beginner in database design.i want to know what will be the database design of any food shop like pizza hut..i have created some tables...i am confuse with design of order table..
employee_details
-ID primary key
-name
-address
-date_of _joining
-salary
product_details
- category_name ,foriegn key
- product_name,primary key
- category
- unit price
-discount
categories
-category_name , primary key
Forms :: How To Design A Simple Graph
May 23, 2011How to design a Simple Graph?
View 1 Replies View RelatedSQL & PL/SQL :: Global Exception In Package Available Outside Package?
Jan 15, 2012I have a package with several procedures which raise and catch an error if a foreign key constraint has been violated. I put the the following code in my package body:
e_ouder_niet_gevonden EXCEPTION;
PRAGMA EXCEPTION_INIT(e_ouder_niet_gevonden,-2291);
Now all the procedures inside the package which catch this exception in the EXCEPTION block work fine. I would like to be able to use that exception outside of my package as well though, how would I do this?
Database Design - Multiple Irrelevant Fields
May 15, 2009I am designing a database as a practice exercise, but have come across a problem.
Here is my design:
Branch Manager Employee
------- ---------- ----------
BranchID ---- ManagerID |---- EmpoyeeID
... | EmployeeID ---- ...
Manager ---- EmployeeIDOfManager
...
Branch
Note: The ... in the tables are just placements symbolizing that there are multiple irrelevant (to this thread) fields.
The problem is with the field highlighted in italics whilst the primary keys are in bold. I need to somehow retrieve that ID, but I can't create a many-to-many relationship.
Forms :: Design Mode - Horizontal And Vertical Scroll Bar
Oct 25, 2010How to create horizontal and vertical scrollbar at a time while design mode??
View 2 Replies View RelatedForms :: Design A Form With Header And Line Level?
May 23, 2011How can we design a form with header level and line level. here i need to place a button in header section.when we press that button, line level values should be populate.
View 1 Replies View RelatedPL/SQL :: Master Detail Form And Required Table Design
Feb 28, 2013I have a contact table that will be used for more than one entity (Customers, Sites, Suppliers, etc.) Using APEX, when we define the master-detail, we need to add a FK to the Detail table -- otherwise the Master-Detail Forms can not be implemented.
I am looking for a way to defined/implemented tables so that I can utilize the same table (Contacts) for more than one Master-details relationship.