SQL & PL/SQL :: Count Of Records In Item List

Apr 17, 2012

One of the tables is having

SQL> select count(1) from item_list;

COUNT(1)
----------
14356529

To fetch the count using the above query , it takes 6 mins. There are no other processes running in the DB. The fragmentation % on this table is showing 16.3%

I tried finding the fragmentation using the below query.

select table_name,
round((blocks*8),2) "table size kb",
round((num_rows*avg_row_len/1024),2) "actual data in table kb",
round((blocks*8),2)- round((num_rows*avg_row_len/1024),2) "wasted space kb",
((round((blocks*8),2)- round((num_rows*avg_row_len/1024),2)) / (round((blocks*8),2)) ) *100 "percent fragmented"
from dba_tables
where table_name like ITEM_LIST%'
and owner = 'TEST_USR'
and blocks != 0
order by 4 desc

TABLE_NAME table size kb actual data in table kb
------------------------------ ------------- -----------------------
wasted space kb percent fragmented
--------------- ------------------
ITEM_LIST 5163360 4318302.27
845057.73 16.3664306

View 15 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 :: How To Avoid (no List Elements Defined For List Item) Error

Sep 27, 2011

I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".

I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.

View 1 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

Forms :: FRM-30351 / No List Elements Defined For List Item

Oct 30, 2011

DECLARE
CURSOR GRP IS
SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc AName,Letter_Group_ID
FROM Hrs_Group;
BEGIN
Clear_list('Letter_Group_ID');
FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
END;

FRM-30351: No list elements defined for list item.

List LETTER_GROUP_ID

View 4 Replies View Related

SQL & PL/SQL :: Procedure To Delete Records / Count Number Of Records Has Been Deleted

Feb 21, 2011

I have written the following PL/SQL procedure to delete the records and count the number of records has been deleted.

CREATE OR REPLACE PROCEDURE Del_emp IS
del_records NUMBER:=0;
BEGIN
DELETE
FROM candidate c
WHERE empid in
(select c.empid
from employee e,
candidate c
where e.empid = c.empid
and e.emp_stat = 'TERMINATED'
);
[code]....

View 6 Replies View Related

SQL & PL/SQL :: Returning List Of Records That Do Not Have Associated Records From A Sub-query

Sep 6, 2010

I am running a query in our Clarity PPM database to return a list of all Support projects. This returns a simple list of project code and project name:

The query has the project resource tables associated with it, so I am able to list all resources allocated to the project. But for now i am only selecting a DISTINCT list of projects.

Query for anyone interested:

Select distinct
Project_code,
project_name
from
niku.nbi_project_current_facts nbip,
niku.odf_ca_project cst,
niku.prtask t,
[code]........

I have a separate query which returns a list of support resources.

select res.full_name, res.unique_name , dep.description
from niku.srm_resources res,
niku.pac_mnt_resources pac,
niku.departments dep
where res.unique_name = pac.resource_code
and pac.departcode = dep.departcode
and res.is_active = 1
and description like 'IMS%'
and UPPER(dep.description) like '%SUP%'

What I need to be able to do in the first query, is return only projects that do NOT have a resource that appears in the resource list in the second query.

(the res.unique_name field in the second query can be linked to the same in the first query)

Logically, the process would be:
1. Identify Support Project
2. Identify Resources allocated to the project team
3. Compare with List of Support Resources
4. If any Resources in that list do NOT appear on the project, then return project.

View 18 Replies View Related

Forms :: How To Count In List Block

Oct 1, 2011

I have a list block of two fields item_name, item_price. User can enter as many item`s as she/he wants. But, before saving the record system should calculate the total and give error if sum is grater then or less than 100.

View 2 Replies View Related

List Count Of Rows Where DATE Field Is Not Null?

Apr 1, 2010

I need to list a count of rows where a DATE field is not null and group those counts by day.

Here's my sql so far...

SELECT
COUNT(DQ_DISTRBTN_DATE) as DQR_DIST,
DQ_DISTRBTN_DATE as DIST_DATE
from
ETL_PROCESS.BATCH
group by
DQ_DISTRBTN_DATE;

Because DQ_DISTRBTN_DATE contains time, how do I modify to achieve the desired result?

View 2 Replies View Related

Forms :: How To Validate List Item

Nov 22, 2010

I am working on form 6i..

I have developed a form with some text items,a list item and a image item...

list item......account_list(values....company,individual)
text_item..... company_name..
text_item.....image_path...

i have attached a pop up menu to image item... Add image and upload image...

When i click on 'Add image' the image path is getting enabled.. it is fine but when i am changing the account_list i need enable and disable the 'Company_name' text item... How can i achieve this??

I have tried it in when-validate-trigger on account_list...

if account_list=individual then
set_item_property('company_name',enabled,property_false);
else
set_item_property('company_name',enabled,property_true);
end if;

But no use of this....

how can i achieve it??

View 5 Replies View Related

Forms :: Dynamic List Item

Sep 7, 2011

how to create dynamic list item ????

View 5 Replies View Related

Forms :: No Data In List Item?

Mar 1, 2011

I am populating the list item from predefined record group. the form is running fine but it didnt show the data present in the record group. I have placed the following code in Pre-Form trigger.

declare
list_id item;
rg_id recordgroup;

begin

rg_id := find_group('RECORD_GROUP9');
list_id := find_item('block2.list4');
clear_list(list_id);
populate_list(list_id, rg_id);
end;

View 7 Replies View Related

Forms :: Populating A Value For List Item

May 20, 2010

I created one list item.which is populating values from list item query dynamically.If i select a particular value from list it will create new record.for the new record line i want to display list item as 'complete' (i.e not exists in the list).At this time i don't want the list also.How can i assign value to the list item in this scenario?

View 9 Replies View Related

Forms :: List Item Becomes Inactive After Using Once

Dec 6, 2012

i have a form having 5 listitems for making selections. once selecting through listitems i am adding this selection into below datablock by a ok button and saving it into database by a ok button. as i made one selection and press ok buttton it's working fine but after this when i want one more selection through listitems, listitems becomes inactive. it's not working after one selection. my coding on ok button is like this:

begin
select distinct lcode intolcode_ss from vac_view where locality=:vac_view.locality;
select distinct hid intohid_ss from vac_clr_vu where vr_no=:vac_view.vr_no;
:prop_temp.vr_no :=:vac_view.vr_no;
:prop_temp.qtr_type :=:vac_view.qtr_type;
:prop_temp.locality :=:vac_view.locality;
[code]....

may be it's all because of clear_list('vac_view.locality'); but i have to put this as i want to make clear all listitems after making each selections.

View 1 Replies View Related

Forms :: List Item INDEX

May 21, 2010

Is that any function or bult in there to find list item's currently selected index number.

View 4 Replies View Related

Forms :: List Item Not Working In 10g?

Jan 28, 2011

I want to dynamically populate a list item such that the item list should show the name and its value should enter in the background.

I have tried by writing a query in record group, populated it. the list is showing the name in a list item which is not database item. On this List I have written a trigger which is fetching the value to another text item. It is working well but I am not convinced by this method.

for reference, i want if customer select A then list should show balanced and its value is 1when B then list should show lag,lead,advanced... values 2,3,4,.. respectively.

View 3 Replies View Related

Forms :: Set_lov_property With Respect To List Item

May 21, 2013

I have a multiple data block. There is a list item present on the form having three types INVOICE,BOE and MANUAL. When I select 'MANUAL' , that LOV should not appear for a particular item on the form and the user should be able to insert the value manually and validate manually. I did use set_lov_property, but did not get the correct usage.

I think set_item_property with VALIDATE_FROM_LIST property won't work as it sets the same property to whole column once it is fired. So if I write set_item_property for MANUAL it would set the the column, VALIDATE_FROM_LIST property at once when it is fired, not allowing me to the set properties for that column according to INVOICE and BOE where I would require the LOV. I want it to go with the item instance and therefore opting for set_lov_property but not clear with the syntax given

1) SET_LOV_PROPERTY
(lov_name VARCHAR2,
property NUMBER,
value NUMBER);

2) SET_LOV_PROPERTY
(lov_name VARCHAR2,
property NUMBER,
x NUMBER,
y NUMBER)

View 1 Replies View Related

Forms :: Populating Data In List Item?

Jul 15, 2005

I have created a item, CO_NAME as List Item and list style is Poplist.

I have written following code in when-new-form-instance to populate the data from table to item.

DECLARE
rg_name VARCHAR2(40) := 'COMPANY';
rg_id RecordGroup;

[Code].....

But when I run the form, Oracle Error - FRM-41337:Cannot populate the list from record group.

View 2 Replies View Related

Forms :: List Item Populates But Not Accepting Value?

Jul 31, 2013

i have a listitem, in which items populates as required but when i select any value out of these populated value, it is not displaying as selected, means i'm unable to select value from that listitem.

View 1 Replies View Related

Forms :: Scroll Bar Coming In List Item

Dec 10, 2010

I have a list item with two values,0 and 1. However when i click on the list item scroll bar appears. My tester is saying for two items she doesn't need a scroll bar.

View 3 Replies View Related

Forms :: Database Block To List Item?

Oct 12, 2010

I have a form which contains two canvas.In the first canvas, i have a data block which contains two columns(database item of both are no). In second canvas i have a list item.

My problem is how to pass the value(s) of this data block to the item list which is present in second canvas.

The requirement user has given is such that the user will enter different categories, and in the second canvas where the main datablock is present, will contain a list item in data block which should show the data entered by the user.

View 1 Replies View Related

Forms :: To Create A Dynamic Item List

Sep 12, 2011

i have created a small table which contains only name of cities.On form level i want to create a dynamic list of the name of these cities just by clicking on the textbox without doing any hardcoding.

View 25 Replies View Related

Forms :: Sorting Values In List Item

Dec 15, 2010

I have two list items and from left list item values are populated to right list item through Add and Remove buttons and vice versa.My requirement is

1.) I need to sort the values of list item whenever a new element is added to the list item.

View 1 Replies View Related

Forms :: Creating List Item With Time?

Jul 9, 2013

Oracle Developer Suite 10g

I want to create List item with time .

like in pic when I click on upper side at list item increase time and other side decrease time.

View 1 Replies View Related

Forms :: Populate Record In List Item?

Aug 6, 2010

i want to popultate record in list item.... and write the follwing code...

PROCEDURE POPULATE_REC_IN_COMBO_BOX IS
RG_NAME VARCHAR2(500) :='RGGROUP';
RG_ID RECORDGROUP;
ERRCODE NUMBER;
BEGIN

[code].....

when i call this code then it returns the 2 errors:

1. FRM-41072: Cannot create Group RGGROUP.

2. FRM-41076: Error populating Group.

View 16 Replies View Related

Forms :: List-item Selection Not Working?

Oct 3, 2012

i am facing a problem in functionality of a form as there are different search parameters:
date from: text item-->mandatory
date to: text item---->mandatory
house type: list item-->optional
form_status: list item->optional
order by: list item---->optinal

untill i don't select house type by list item everything is working fine and gives desired result, even with house type if i select any house type result is fine but as i select last list item of house type which is null as i want result without house type then it gives no any data as data is present in database.

for example:
date from: 20-05-2009
date to: 21-05-2009

with these two i got the correct result, then i select
house type: 3

i got the correct result and when i change list item to any value like: 1,2,3.....it is working fine but as i want result without house type by selecting the null value in list item as:
date from: 20-05-2009
date to: 21-05-2009

it is not picking any data from database. but the same search criteria in 1st case as i described above giving result.
declare
qry varchar2(5000);
n number;
alert number;

[code]...

View 5 Replies View Related

Forms :: List Item Background Color?

Nov 25, 2010

In the attachement, i have one record. if i click on the list_item then it is showing fully blue as background colour, but i want like if i click on the list item then only current value background should show as blue rest of the values white in background colour.

View 1 Replies View Related

Forms :: Disabled List Item Will Be Enabled Accordingly Just By Clicking

Feb 4, 2013

I have a problem in oracle forms. I have a block that displays five records in list item. On load, it will query two data in my table. So the list item (poplist) one and two enabled. (The default of oracle forms - List item one and two are enabled and the rest are disabled because one and two have data).

My problem was, what work around will I gonna do so that if I pressed the mouse in the third list item it will automatically enabled (for a new record) and if I pressed the list item one or two the third item will stay disable (even the fourth and fifth) because simply the user wants to update the item one or two in the list.

View 2 Replies View Related

Forms :: List Item From Query With Refresh Button

Apr 19, 2010

i want to make a list item from query..i have a form on emp

the list item is on deptno showing the department name its work fine the form are opened when the user enter the new empno they need a other department

the others users or same user are inserting the department from master form

user open the list item it will not show the inserted values until they have to reopen the form because the trigger code inserted on when new form instance but i need a refesh list when user click on list item without reopen form or any refersh button

View 4 Replies View Related

Forms :: List Item Label Of Current Selection?

May 9, 2012

How to get the label (not value) of current selection in a List Item.

View 7 Replies View Related







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