Forms :: How To Design A Simple Graph
May 23, 2011How to design a Simple Graph?
View 1 Replies
ADVERTISEMENT
Forms :: Create Line Graph On Oracle 11g?
Mar 12, 2013how can i create line graph on oracle 11g forms
View 1 Replies View RelatedForms :: Pie Chart And Vertical Bar Graph In Oracle 10g
Oct 8, 2013I have two graph pj item in oracle block one is pie chart and other is vertical bar graph... there is color display in bottom of pie graph which is red=50,yellow-30 and orange=20 ..and in vertical bar red=50,but orange=30 and yellow is 20 ..means orange and yellow is interchange in bar graph..how i can same the both graph value..
the graph is populate through cursor and graph properties is setting through set_custom_propert();
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 RelatedForms :: Design Time Insert And Update Allowed For Block
Jan 10, 2011I create databalock - LC_REQ_PO_ITM_DTLS...In design time Insert and update allowed for that block - YES. While i execute query, i write procedure like this
GO_BLOCK('LC_REQ_PO_ITM_DTLS');
EXECUTE_QUERY;
SET_ITEM_PROPERTY('pb_item_cd', enabled, property_false);
SET_BLOCK_PROPERTY('LC_REQ_PO_ITM_DTLS',INSERT_ALLOWED, PROPERTY_FALSE);
SET_BLOCK_PROPERTY('LC_REQ_PO_ITM_DTLS',UPDATE_ALLOWED, PROPERTY_FALSE);
but when i press execute button , then data comes properly on that bloack..but i click on that block, error comes like this - 'You can not create record here '.and data disappearing..
Forms :: How To Design Hierarchical Tree Menu For Calling Reports
Mar 17, 2013How to design Hierarchical Tree Menu for calling forms & Reports.
View 2 Replies View RelatedForms :: Simple Data Block - Serial Number Generation
Jun 2, 2010I have created simple data block by wizard and taken tabular layout 10 rows and 6 columns
i want to generate serial number on first column .....
what need to use..?
Forms :: Wait Event During Execution Simple Select Statement
Jul 19, 2013Yesterday i got wait event when executed simple select from table.This select was like:
SELECT emp_number from employer where subs_id = 111
I got one row, select is very fast.In our Core Bank System we have package with function which returns such information. I tested this select on test DB, and nothing wrong. But when I executed such select and package on Production DB, DB Admin saw that 88 sessions waits when my session release the resource. But what can happen, it was simple select? I used PL/SQL developer to get information from table:
1) SELECT emp_number from employer where subs_id = 111 then
2) Package with this function
Another users used Oracle Forms screen to execute package. How simple select statement could stop all DB?
BANNER
1Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
2PL/SQL Release 10.2.0.5.0 - Production
3CORE 10.2.0.5.0 Production
4TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
5NLSRTL Version 10.2.0.5.0 - Production
[code]...
Forgot to say that after succeful execution on Prod DB I disconnected, and in EM my session was INACTIVE.
Forms :: Image Path Save In Database And Image Name As Design Number?
Jun 3, 2009I create a simple table for image
CREATE TABLE image_table (
Design_no varchar2(10),
filename VARCHAR2(255) PRIMARY KEY,
image LONG RAW);
Then i create simple block of image_table
its show me in this website [URL] My question is i don't want to give my form path always.i want to save my picture path in my database and the name of my picture always same as my design_no column.
For example i want to save a picture in my database i will copy my picture in d:shahzaib1234.jpg now i want the path d:shahzaib save in database and when i copy my picture which path= d:shahzaib and file name = Design no its will automatically save in database.
Export Graph From Oracle Enterprise Manager?
Aug 12, 2013is there a way to export/download graphs that are shown on Oracle Enterprise Manager? I tried to find some buttons that make it possibile, but I'm unable to find them...
View 1 Replies View RelatedReports & Discoverer :: Get Graph Output At Report Level?
Dec 24, 2010get Graph output at report level.
View 1 Replies View RelatedReports & Discoverer :: Change Format Of Figure Display On Bar Graph?
Aug 18, 2009how i can change format of figure display on bar graph(data labels) in oracle 10g graphical reports .i want to change format fom 99.99 to 9999 .
View 1 Replies View RelatedApplication Express :: Drag N Drop Graph In Gantt Chart?
Aug 26, 2013I'm gonna create a Gantt chart on Oracle APEX and want to re-size, move the graph into other line..how to control the graph itself (just like javascript, ajax and anychart API...) URL.....
View 0 Replies View RelatedApplication Express :: Customize Tooltip In Flash Chart / Graph
Dec 4, 2012Is there any way I could customize tooltip (when you go over the bar in the report, small box with the value appears).I would like to display different values there.
View 0 Replies View RelatedReports & Discoverer :: Graph - Repeating Frame (Change Dynamically Y And X Axis Title)
May 23, 2012I'm presently creating a Graph on a repeating frame.
I made a query with a group that pointing to the repeating frame.
The problem : I want to change dynamically the Y and X axis Title.
The graph accept user parameter inside the XML file. But how to make it dynamically based on SQL query?
I try with formula, but can't make it work with a group. I have to put the formula at Report Level, but to make it dynamically for each group i have to make it work at the group Level.
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 RelatedXML DB :: Simple Node With Attribute?
Jan 4, 20131. i register scheme like this
DECLARE
schemaurl VARCHAR2(256);
xmlschema xmltype;
BEGIN
[code]...
/2. i try to insert XML
insert into TMP_SPM_ACTLOGLINE values (xmltype(
'<ACTLOGLINE xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
[code]...
The question is how should the scheme look like to insert this XML?
PL/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 RelatedSimple Update Query Not Returning More Than One Row?
Sep 9, 2009I've just started with the Oracle SQL and come from a heavy MS SQL background and I understand that here are some natural differences in the syntax but I'm stumped as to why the following sql represents a problem:
update MASTERMICODES t1
set t1.TEMPTA = ( select t2.TAFCODE
from TA_FEATURES t2
where t2.FCODE = t1.FCODE
)
It returns Error report:
SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery returns more than one row"
*Cause:
*Action:
I want it to return more than one row...in fact I want it to make on all rows that have the same fcode between tables.
SQL & PL/SQL :: Get Number Of Records (not A Simple Count())
Mar 4, 2010using the sql statement in SQL server. I noticed some of the sql syntax are different. My sql statement is as below;
---Select fieldA, Sum(fieldB+fieldC) as fieldD, fieldE, fieldF from TableA group by fieldA, fieldE, fieldF ---
the output will be as below;
fieldA fieldD fieldE fieldF
------ ------------- ------ ------
fieldA fieldB+fieldC fieldE fieldF
However, I need to have the total of no of records displayed for the sql statement and I need it in one sql statement with the one above so that I can display the total no of records along with the information for each field.
SQL & 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 RelatedSQL & PL/SQL :: Compilation Error With Simple ELSIF
Mar 12, 2010what I don't get is what is wrong with my ELSIF statement? Majic program that will guess how much you are worth
ACCEPT s_first PROMPT 'Enter your random letter'
DECLARE
random_letter VARCHAR(20);
personal_worth VARCHAR(20);
BEGIN
[code]....
Security :: 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
SQL & PL/SQL :: Oracle SQL Simple Table Verification?
Feb 27, 2012I'm taking my first SQL class and trying to replicate the code in this picture. I'm wondering if the code is space-sensitive in certain areas
For example, in the very last line, does it matter if I have:
CONSTRAINT ORDER_LINE_FK2 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT_T(PRODUCT_ID));
vs.
CONSTRAINT ORDER_LINE_FK2 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT_T (PRODUCT_ID));
(where the second one has a space between PRODUCT_T and (PRODUCT_ID));
Also, I don't have Oracle SQL on my computer.
CREATE TABLE CUSTOMER_T
(CUSTOMER_IDNUMBER(11,0)NOT NULL,
CUSTOMER_NAMEVARCHAR2(25)NOT NULL,
CUSTOMER_ADDRESSVARCHAR2(30),
CITYVARCHAR2(20),
STATEVARCHAR2(2),
[code]....