SQL & PL/SQL :: ITEM Not In CURR_STS Table Not To Be Displayed

Jun 26, 2012

CREATE TABLE CURR_STS
(
LOB VARCHAR2(100 CHAR),
FP VARCHAR2(100 CHAR),
BRAND VARCHAR2(100 CHAR),
ITEM VARCHAR2(100 CHAR),
SUB_ITEM VARCHAR2(100 CHAR),
PART VARCHAR2(100 CHAR),
COST NUMBER
[code]...

ITEM not in CURR_STS table not to be displayed ( HERE SKU2) , but SUB_ITEM, PART coming under a ITEM if present in SAME ITEM in CURR_STS ( here SKU1 is common in both CURR_STS and PRIOR_STS) to be displayed. Trying to achieve this through OUTER join queries.

SELECT a.lob,a.sku,a.mod,a.part,a.cost curr_cost, b.cost prior_cost
FROM curr_sts a, prior_sts b
WHERE a.item=b.item(+) and a.sub_item=b.sub_item(+) and a.part=b.part(+);

View 3 Replies


ADVERTISEMENT

Forms :: Number Of Records Displayed In List Item Is More Than 1

Dec 28, 2010

Actually m working on oracle 10g forms. I have a list item in which no. of records displayed is 10. I am populating this list item through a record group. I want when user select a value from first record then he should not be able to select the same value in further record of that list item.

View 12 Replies View Related

Forms :: User Clicks On Declaration_no From Header Table / Other Records Will Be Displayed

Jun 26, 2013

I need to populate records from a child table when the user clicks on a record in the header table..The difficulty is that the user needs to be able to edit a field from the child table and there could be 1 to many records. When the user makes a change , I don't want the 'do you want to save changes' error to appear..

the user will only be able to update field 'amt'.When the user clicks on 'declaration_no' from the header table,other records will be displayed. URL.....

View 5 Replies View Related

PL/SQL - See If Given Item In Table Or Not And Then Raise Exception?

May 2, 2009

I'm trying to figure out how to simply check and see if a given item is in a table, and if its not, then raise an exception.

for example i have a table employees and each employee has a primary key employID. I need to write a procedure where employID is given as a parameter and if the one given isnt in the table then raise an exception.

View 3 Replies View Related

Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item

May 22, 2010

I have 2 items in my form:

1) Text Item
2) Tlist

Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .

View 1 Replies View Related

SQL & PL/SQL :: JavaScript And Oracle DB Updating A Table Item?

Feb 19, 2010

I want to use java-script to open a prompt to see if the user wants to change the date of a work order (Located in Work_order_info called "opened_date")

What I have so far:

var n = prompt("Is the checklist starting now? (Type either y or n)", "y or n");
if (n == "y" || n == "Y"){
alert("The opened date has now been changed!");
}else if (n = "n" || n == "N"){
alert("The opened date has not been changed!");
}else{
alert("You needed to type either n or y, nothing else!");
}

I'm not entirely sure how to tell the table to change the opened_date to sysdate. I'm sure it's really simple >.

View 2 Replies View Related

SQL & PL/SQL :: How To Display Missing Item Names For Each Item Code

Feb 16, 2010

I have a table with the following data.

item_code item_name
101 Pen
101 Pencil
101 Scale
102 Pen

[Code]...

My aim is to display the missing itemnames for each itemcode.

For each ITEM_CODE there should be four items i.e Pen,Pencil,Scale and Marker If any itemcode missed any of the itemnames those records should display in the output.

So the output should be like this

101 Marker Because the item Marker is missed.
102 Pencil Because the items Pencil and Marker are missed.
102 Marker Because the items Pencil and Marker are missed.

For itemcode 103 no records should be displayed because it having all four itemnames.

View 21 Replies View Related

Forms :: Move Cursor To Another Item From WHEN-VALIDATE-ITEM

Apr 19, 2012

I need to move to control to another item in a same block from WHEN-VALIDATE-ITEM trigger. [WITH OUT USING ANOTHER TRIGGER]

View 6 Replies View Related

SQL & PL/SQL :: Results Of Query To Be Displayed In One Line

May 19, 2010

I have this query:

select distinct event_number from events_total WHERE event_id = 16395493
minus
select distinct event_number from event_details_ford WHERE event_id = 16395493

result of which is :
6L2Z-7861693-AAC
6L2Z-7862187-CAC

i want to put this in dynamic sql where clause :

where event_number in ('6L2Z-7861693-AAC','6L2Z-7862187-CAC'). and if the result of the query is only one number, then where event_number in (6L2Z-7861693-AAC) result of the query can be NULL also. but i think i can use IF condition for "SELECT ..WHERE event_number in " query

so how can i put the results of query in one line, so that i can use it in where clause.

View 12 Replies View Related

Forms :: Filter The Records Displayed

May 11, 2010

I have a block in the form which is based of a table as data source and so when i query on the form using a execute_query inbuilt statement is fired and all the records in the table behind is retrived and displayed. Also if i need to update any record i can do in on the screen and use commit_form so that all the changes go into the underlying table. Now my problem is when i retrieving my records i want to filter those records based on some conditions to be displayed in the form and not all records to be retrieved. Is it possible to do it if I am using the execute_query inbuilt and my block is based of a table?

View 8 Replies View Related

Reports & Discoverer :: Value To Be Displayed In Header

Oct 26, 2010

I have a requirement like this, There is a temporary table with one number column. This column would be updated in between pages trigger. In the header I want to display the value from this temporary table on each page. I tried this by putting a frame and displaying the values, but it displays same value for all the column.

The table is properly getting updated in between pages trigger. I just want to know how to print the refreshed value in the header.

View 3 Replies View Related

SQL & PL/SQL :: Duplicate Rows Displayed For A Column

Mar 30, 2013

column sid format 'a5'
column serial# format 'a10'
column mins_running format 'a15'
column sql_text format 'a100'
set linesize 200
set pagesize 30

[Code]..

I am running this code, and the output shows multiple lines.

TRIM(S.SID) TRIM(S.SERIAL#) MINS_RUNNING SUBSTR(Q.SQL_TEXT,1,70)
---------------------------------------- ---------------------------------------- --------------- ----------------------------------------------------------------
700 46592 242.08 Select count(*) as count, case when count(*)>0 then 'FAIL' else
700 46592 242.08 'PASS' end as result
from (SELECT cv.code_value
FROM code_valu

[Code]...

Is there a way to wrap up the column for SQL_TEXT VARCHAR2(64) so that I can 1 row for the output?

View 14 Replies View Related

Forms :: Stacked Canvas Not Displayed?

May 13, 2011

is that datablock should have related to show the stacked which is hidden in content canvas

i have attached the stack.fmb

View 9 Replies View Related

Application Express :: How To Search By Displayed Value

Apr 15, 2013

When a format mask is applied to numeric field in an Interactive Report, e.g. 999G999G999G999G999G990, search operations from the Search Bar do not match any entries if the mask characters are included. For example, the data value from the database is: 2251343000. When the above, example format mask is applied, this is displayed as 2,251,343,000. However, if the user enters 2,251,343,000 in the search bar (which would be the natural thing to do), nothing matches. On the other hand, if the user enters 2251343000, a match is found.

This seems like counter intuitive behavior to me since the whole point of the tool bar is to allow "self-service" for the user. Training them to remove commas, dollars signs or whatever is not very popular.

View 2 Replies View Related

SQL & PL/SQL :: Access Individual Item From A Table Of Type ROWTYPE

Jun 1, 2010

Script for test:

CREATE TABLE TEST(empno VARCHAR2(4), empname VARCHAR2(50), empstd NUMBER(2))
insert into test values(0001,'A',2);
insert into test values(0002,'B',5);
insert into test values(0003,'C',2);
insert into test values(0004,'D',7);
insert into test values(0005,'E',9);

Now I want to get empno for the particular employees based upon subscript and I have written below

DECLARE
CURSOR cur_rec
IS
SELECT *
FROM TEST;
TYPE cur_type IS TABLE OF cur_rec%ROWTYPE;
v_cur_rec cur_type;
BEGIN
OPEN cur_rec;
FETCH cur_rec
BULK COLLECT INTO v_cur_rec;
[code]....

how to access individial item froma table of rowtype data.

CM: Added [code] tags, please do so yourself next time, see the orafaq forum.

View 5 Replies View Related

Forms :: Fetch Record From Table Using Item Code

Jun 7, 2013

i want to fetch the data in my form from table, by using item_code.

eg when i write the item_code its value get matched in same table and fetch the another

columns by item_code.

View 1 Replies View Related

SQL & PL/SQL :: Extracted Data Is Displayed In Wrong Format

Feb 14, 2013

I use SQL to extract data from Quality Center (QC) to excel. I have a field type String. It contains the following values.

1) 1161, 1162, 1163
2) DHM, 162
3) DTH, 163
etc

But when i extract this to excel the data is displayed as
1) 116111621163
2) DHM, 162
3) DTH, 163

The value in the first row is displayed with out commas. How to extract the data as it is in the field?

View 7 Replies View Related

Forms :: Sequence Number To Be Displayed In Form

Mar 27, 2012

In my form I have a submit button, when i click on it a sequence number to be generated and displayed in a text box.

I have created a sequence and tried inserting into table, it works fine however it's not getting displayed in form.

Note: Tried giving sequence.sequence_name.nextval in initial value of the text box, didn't work showed FRM-11324 error.

--When button pressed--

DECLARE

v_seq number(20);

BEGIN

select seq_name.nextval
into v_seq
from dual;

[Code]...

View 15 Replies View Related

Application Express :: How To Set Default Displayed Columns

Jun 12, 2012

Env: APEX 4.1

For example, initially I created the reprot source as select c1, c2, c3 from t; later I added c4. But i was unable to figure out how to make c1, c2, c3, c4 become default displayed columns. I always have to click Action -> Select Columns, then move C4 from "Do not Display" to "Display in Report".

View 8 Replies View Related

Forms :: Dynamically Setting No Of Records Displayed In Block

Jun 25, 2010

i have a cursor which selects the codes based on the school records now i have a multi record block b1 the requirement is that if no of records selected in cusor is 10 then in block b1 10 records should be displayed and if it is 15 then 15 records should be displayed. Is there any way that i can set the no of records displayed in a block dynamically.The block b1 is non database block i am only using a create_record to populate the block.

View 2 Replies View Related

Forms :: Dynamically Change Number Of Records Displayed?

Mar 31, 2011

I am currently on a project which has a requirement of changing the number of records dynamically. Oracle Forms version 10g.

View 2 Replies View Related

PL/SQL :: Query To Be Displayed Grouped By Year / Month And Then By Assignment?

May 27, 2013

I have the following table structure with values

CREATE TABLE DUMMY
  (
    SR_NUMBER          VARCHAR2(100 CHAR),
    ASSIGNMENT_GROUP   VARCHAR2(100 CHAR),
    REASSIGNMENT_COUNT VARCHAR2(100 CHAR),
    CREATED DATE,

[code]...

?I have the following requirement, the output should be:

Ticket count (sr_number)
% of tickets inside DL
Number of tickets inside DL
Average cycle time (cycle time = closed date - created date)
Total cycle time (cycle time = closed date - created date)
Number of reassignments (sum)

DL - (deadline) formula is, closed date <= target_date

This should be displayed, grouped by year, then month and then by assignment group. The values should be in descending order(dates) Not sure how group by will work here.I am able to write the basic code for the above, but group by based on year, month and assignment group is pretty confusing to me.

View 10 Replies View Related

Workflow :: How To Find Actual Responder Name Displayed In Notification

Feb 13, 2013

Where are the details of the Actual Responder Details stored in the case of the below scenario

If a notification for one user was closed by another user through access to the first user's worklist, the name of the second user, who actually took the action, is displayed as the responder.

I am only able to find the Original Recipeint username in the wf_notifications table.But where will the details of the Actual Responder name displayed in the notification be stored.

When I use the "wf_notification.Responder" function, I get the Original Recipeint username of the user but not the one who acted on the notification. Is there ANY way by which I can get the Actual responder user name who acted on the notification

select responder from wf_notifications where notification_id = <nid> also gives me the Original Recipeint username of the user but not the one who acted on the notification

View 5 Replies View Related

Forms :: Possible To Pass Records Displayed To Report As Parameter

Jul 20, 2011

In my application (forms6i) initially data will be displayed in a non-database block after a lot of calculations and validations which is time consuming.

Now, if the user want to print it as a report, we store the displayed data in a dummy table and run the report using that dummy table and then delete records from it.

Is it possible to pass the records displayed to the report as a parameter so that I can avoid Unnecessary add/delete records?

View 1 Replies View Related

Application Express :: Blob Downloaded Image Not Displayed

Dec 18, 2012

We have apex application with one record report that shows image.We use database procedure to show image.And call it in apex like:

'<img src="show_image?p_id=' || NVL(dp.id, 0) || '" height="200" width="200" />' as image

But the image is not shown. We only see broken image icon.With right click on broken icon, we can save it and it's actual image we want to display.

If we call procedure like: URL.....

If we use the same procedure on another table with images which are smaller, then the image is shown.Minimum image length in table A is (DBMS_ LOB.getlength (file)): 105243..Maximum image length in table B is: 1702. URL....

View 7 Replies View Related

Forms :: Resetting The Sequence And Dynamically Displayed Block

Nov 29, 2010

Is there any way could alter the sequence depending on specific condition to start with 1 in the form builder?

i wanna to reset the sequence to 1 whenever the month change.is there any way?

Could i make detail block invisible and whenever button pressed i will display the block? I want to put the where clause for that block in the button and if the button did not pressed i want to display nothing in the detail block?

View 1 Replies View Related

Forms :: How To Populate Table Column Heading In List Item Of Oracle

Jun 26, 2013

how should i populate table column heading in list items of forms? I've create lov to select the column, then i have 10 separate list items. once i select the table from lov then list item should get populated with selected table column.

View 2 Replies View Related

Forms :: Created Block For Table On Tabular Style - Validating Item?

Oct 10, 2011

I created a block for EMP table on tabular style. if in first line empno entered is 1then i don't want to allow the end user to enter 1 in second line. but when-validate-item is not working because first_record and next_record is not allowed. I need to validate before saving the data into emp table and immediately after empno is entered into empno item.

View 16 Replies View Related

Forms :: Insert Record In Table When One Of Item In Database Block Is Filled?

Sep 11, 2012

i want to insert a record in table when one of item in database block is filled..from which property i knw my one of field in block is filled or not.

View 2 Replies View Related

Application Express :: Display Page Item Values In HTML Table

Sep 7, 2012

I would like to have a table in HTML region and to display in the table some Page Items from the page.

I got the code like this:
{
<table>
<tr><td>&P1_ECEMEA_ASSISTANCE</td></tr>
<tr><td>&P1_ECEMEA_WIP</td></tr>
</table>
}

It shows the Page Item names as text, not the values. However this code without the table tags:

{
ECEMEA Request for CQT Assistance: &P1_ECEMEA_ASSISTANCE.
ECEMEA CQT Work in Progress: &P1_ECEMEA_WIP.
}

works and the Page Item values are displayed.

Is it possible to display the Page Item values in the HTML table at all or I have to use a different method of showing the values in a table? The above is only a snippet of the code. I need to display about 30 Page Items, formatted in a table with headings.

what kind of region is the best to be used or if I should only use some escape symbols in the table code.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved