SQL & PL/SQL :: How To Count Different Items With One Sentence

Nov 4, 2013

CREATE TABLE "CIM_TEST"
(
"NAME" VARCHAR2(60),
"COUNTRY" VARCHAR2(100),
"CITY" VARCHAR2(100),
"TOWN" VARCHAR2(100),

[Code]..

How to count different items with one sentence instead of above?

View 10 Replies


ADVERTISEMENT

Forms :: How To Count Number Of Items Present In A Data Block

Aug 20, 2011

how to count how many items present in a particular data block in oracle forms 10g.whether it is a text_item or display_item or list_item etc is there any method to do this.

i have written this when-button pressed but the problem is how to get the next item name in the block

DECLARE
V_COUNT NUMBER:=0;
V_FIRSTITEM VARCHAR2(100):='';
BEGIN
GO_BLOCK('BLOCK_ITEMCOUNT');
V_FIRSTITEM := GET_BLOCK_PROPERTY('BLOCK_ITEMCOUNT', FIRST_ITEM);
LOOP

[code]....

View 3 Replies View Related

Forms :: How To Bind Hierarchy Tree Items To Text And Other Items

Jan 31, 2012

I have already done a hierarchy tree. Now I'd like to make it bind to text items. When i click a node, it should automatically be bound to text items.

My tree is about sections of students, now when i click a specific section to view its corresponding subjects it would be displayed on text items.

For example:

+Sections
+First Semester
+LM2
+LM3
+Second Semester
+LM4
+LM5

When i would click on LM2 node, its subjects should appear immediately.

View 1 Replies View Related

Meaning Of Sentence SRW.USER_EXIT?

Apr 9, 2013

I am developing in the Report tool.I wonder what the meaning of the sentence SRW.USER_EXIT, and arguments that are used in it.

For example,

srw.user_exit('FND FLEXIDVAL
CODE=" "
NUM=" "
APPL_SHORT_NAME=" "
DATA=" "
VALUE=" "
DISPLAY=" "
DISPLAY=" "
IDISPLAY=" "
IDISPLAY=" "');
return();

View 2 Replies View Related

Performance Tuning :: Next SQL Sentence

Jul 4, 2012

I want to tuning the next sql sentence. In this sql I want to get the hash_value and sql_text of the sentences that it's causing TX blocks. Is it possible?. This sentence works fine but sometimes It's slow.

SELECT DISTINCT hash_value,
sql_text
FROM gv$sql sq
WHERE hash_value IN (SELECT DISTINCT prev_hash_value
FROM gv$session se
WHERE sid IN (SELECT sid
FROM gv$lock l
WHERE type = 'TX'
AND ctime >= 2000
AND l.inst_id = se.inst_id
AND l.sid = se.sid)
AND sq.inst_id = se.inst_id);
[code]....

View 7 Replies View Related

SQL & PL/SQL :: Validate Sentence Syntax?

Dec 29, 2010

Is there some way to validate the syntax of sql sentence without actually executing it? I dont want to check if the objects exist or not, just want to check the syntax.

View 6 Replies View Related

SQL & PL/SQL :: Number Of Active Sessions With Same Sentence?

Oct 20, 2011

I have a RAC on 9i and I want to know the number of active sessions that it's executing the same sql sentence.I'm using this sql but I'm not sure that this query give me te correct result.

SELECT se.inst_id,se.status,se.SQL_HASH_VALUE,se.USERNAME,substr(sq.SQL_TEXT,1,50) SQL,count(*)
FROM GV$SESSION se, gv$sql sq
WHERE se.STATUS='ACTIVE'
and se.username is not null

[code]...

View 2 Replies View Related

SQL & PL/SQL :: How To Extract First 3 Characters From Each Word In A String / Sentence And Separate With Underscore

Oct 22, 2013

I have some strings like

'Net Amount Payable by an Individual',
'Net Amount Payable by an Individual+Tax',
'Total Amount Payable towards Service',
'Total Amount Payable towards Service.+Tax'

I need to extract the first three letters from each word and separate them using an underscore. The output should be as follows for the above strings -

Net_Amo_Pay_by_an_Ind
Net_Amo_Pay_by_an_Ind_Tax
Tot_Amo_Pay_tow_Ser
Tot_Amo_Pay_tow_Ser_Tax

I request to let me know the way to get the ouput as mentioned.

View 4 Replies View Related

PL/SQL :: Search Items One By One

Oct 12, 2012

i have a text field search_part1 in which i put the item for search another text field i send_by which contains items a single item comes in list many times.i have to find the item one by one.i have make this statement for seraching items

Declare
typ varchar2(200);
L_NAME VARCHAR2(50) := :BLOCK3.SEARCH_PART1;
begin
go_block('BLOCK3');
first_record;
loop
if :BLOCK3.SEND_BY = L_NAME then
[code]....

bt the problem is that if a single items comes more than one time then it search only one time and next time it exit.

View 3 Replies View Related

SQL & PL/SQL :: Difference Between Count(*) And Count(1)?

Nov 16, 2009

When we execute select count(*) from table_name it returns the number of rows.

What does count(1) do? What does 1 signifies over here? Is this same as count(*) as it gives the same result on execution?

View 13 Replies View Related

SQL & PL/SQL :: Difference Between Count(1) And Count(*)

Nov 24, 2011

difference between count(1) and count(*). As i know count(*) will give number of rows irrespective of null and count(1) will not count the null.My Oracle version is 10 g.

SQL> select * from t1;

A B C
---------- -------------------- --------------------
1 2 3
2
5

SQL> select rownum,a.* from t1 a;

ROWNUM A B C
---------- ---------- -------------------- --------------------
1 1 2 3
2 2
3 5
4
[code]....

View 3 Replies View Related

Forms :: How To Go Through All Items In The Form

Jul 6, 2010

is there any way or loop to go through all items in a form and check them with a condition ???

View 5 Replies View Related

Forms :: How To Add Text Items At Runtime

Dec 24, 2012

I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?

View 1 Replies View Related

Forms :: Items On Tab Page Getting Invisible?

Oct 12, 2010

when i am selecting a record from a LOV which is associated with a button on a tab page of a tabbed canvas; all the items on the tab page getting invisible. But when i navigate to another tab page and then come back to the former tab page all items reappearing.

What could possibly be the reason for this and how to restrict items from disappearing?

View 4 Replies View Related

Forms :: Populating List Items

Jun 7, 2010

there are 3 radio buttons and 1 list item

i want different options to appear in the list item when choosing different radio buttons.

i've tried to compile the codes and there are no errors.

I dunno what went wrong.

B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME

the following is my
DECLARE

[Code]....

View 2 Replies View Related

Forms :: 6i / Validating Text Items?

Nov 24, 2010

I am working on form 6i.

i need to write validation on text fields like first name,last name,phone no,email id

i have to not allow special char.

View 3 Replies View Related

Forms :: Dynamic List Items

Apr 21, 2011

I want to create two list items. one is for deptno and another is for empno in a single form.

Based on the selected deptno value from first list item i want to populate corresponding empno from second list item. I tried with the fallowing code, it's work fine but the second list is not clears with the existing empno's.

Code for Deptno List item

declare
cursor c is select deptno from dept;
cnt number := 1;
begin
clear_list('LI_DEPTNO');

[Code]...

Code for Empno list item in when_list_changed trigger for deptno list item

declare
cursor c is select empno from emp where deptno = :LI_DEPTNO;
cnt number := 1;
begin
it_id := Find_Item('LI_EMPNO');
clear_list(it_id);
for i in c loop
add_list_element('LI_EMPNO',cnt,i.empno,i.empno);
cnt := cnt + 1;
end loop;
end;

View 3 Replies View Related

Forms :: Numeric Listbox Items?

Apr 12, 2010

I've got a colleague that is trying to populate a list box item with a group of numeric values that represent highway route numbers.

The database view defines the route as a "number".

How can we create a numeric list box? The built-in functions populate_group, and populate_list both expect to get varchar2 parameters.

View 1 Replies View Related

Forms :: Queries On Long / Lob Items?

Feb 2, 2013

how can I have queries on long/lob items in form.

View 1 Replies View Related

Forms :: Two Control Items With Dependent LOV?

Jun 28, 2011

I have created two control items like organization and location and both items contains lovs.here i have to make location lov is dependent on organization.one org contains multiple locations. how to make this change?

View 1 Replies View Related

PL/SQL :: Parse Multiple Items In A Field

Apr 1, 2013

I have a field that contains many part numbers. There can be 2 or more part numbers in the field separated by a space. How can this be dynamically read so you can compare the contents in the where clause to what you are search for? Example Part Numbers in the field: 1X 2X 3X 4Y 5Y 7Y

I would like to read the field and make rows out of the data.

1X
2X
3X
4Y
5Y
7Y

View 3 Replies View Related

Forms :: Triggers In 6i / Which Is Applicable To All Items

Jan 24, 2012

May i know the triggers in forms 6i, which is applicable to all items,blocks and form.

View 9 Replies View Related

Program For Menu - Enter Value To Show Different Items

Jan 13, 2012

I want plsql code for output as follows

menu
enter 1 for veg
enter 2 for non-veg

enter value:

after entering the number it have to show different items like
item1 cost $10
item2 cost $12
.
.
.

i tried this with case with substitution variables. it is asking variable first with out showing the menu. i want menu first then it should ask for entry. what can i do for this.

View 1 Replies View Related

Forms :: How To Save Tlist Items In Database

Sep 25, 2010

my question is this that i have tlist items like

example:

A
B
C
D
E
F
G
H

how to save tlist items in database.

View 6 Replies View Related

Forms :: Multiple Items With Same Database Column Name

Dec 28, 2010

I am coming across a requirement wherein a databse cloumn is shred by 2 fields..( need to append the value to the data-base column for the 2nd field.

I dint test it yet but the form compiled with warning FRM-30431: Warning: Duplicate column name in same block...is it ok to further go or its not allowed at all?

View 3 Replies View Related

Forms :: Moving Data Between Two List Items

Dec 8, 2010

My form has two list boxes and two buttons add and remove. As and when i click add button, the selected value from left hand side list item should get populated to right hand side list item. And When I click Remove button, it should do vice versa.

View 10 Replies View Related

Forms :: Hangs With Large Text Items

Oct 4, 2010

I'm facing a strange problem with one of my client.

Sometimes the application hangs when they are typing in text item defined with 2000 or 4000 char long.

The application needs to be close manually.

The first time we faced the problem, we tought it was due to database locks but the DBA confirmed that everything was OK.

The OAS admin also tried to log the application but nothing special. So we tried to run the application using JRE instead of JINITIATOR and the problem disappeared.

So, my question is, is there known bug about using large text item in Forms 10G? and especially with JInitiator? I tried to find informations on metalink but found nothing.

View 1 Replies View Related

SQL & PL/SQL :: Find All Data Items In Hierarchy Recursion?

Jan 21, 2003

I need to find all "report to" supervisors in a hierarchical chain. A binary search won't work, as each level may contain > 2 supervisors. Example:

1

2 3 4

5 6 7 8 9

10

10 reports to 9
9 reports to 4
5 and 6 report to 2
7 and 8 report to 3
2, 3 and 4 report to 1

Result for all reporting to 1 would be a table containing 2, 3, 4, 5, 6, 7, 8, 9, 10 (order is unimportant!).

I think I need to use recursion. I can do this in C; need code for PL/SQL??? (I can't get the "tree" to display well!)

View 4 Replies View Related

Application Express :: Bug While Copying Items On A Page?

Oct 4, 2012

When I create a new page item via copying from existing page item it fails with the below error code, if there is > or < character in the source of the existing item.Error Source contains <, > or " which are invalid characters. It works fine if I create new item using wizard and then have the same source. I use div tags in the source of my display only items.

View 3 Replies View Related

Application Express :: Items Align In Region?

Dec 18, 2012

I have 2 regions in my application one is html form region and another is tabular form .I created 6 items in html region and created DA for the items to hide according to the value of items and then created tabular form

find below the sample link

[URL]...

user name: aneesmohamed.m@gmail.com
psswd: symphony

once i select the first item(declaration letter) it will show the second item (applicacable) perfectly,but when i select applicable as yes and discrepancy then all the items become misplaced,

View 7 Replies View Related







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