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


ADVERTISEMENT

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 :: Multiple Items Selection In A List Item?

Jan 6, 2011

I have a requirement to select multiple values from a list item and do some manipulations with those values. I tried by integrating the LOV with a text item, but couldn't able to select multiple items. Is there a way to do multiple selection in a list item ?

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

SQL & PL/SQL :: Multiple Field Update

Jun 11, 2011

I have a requirement to load data into database column based on the value coming from input field.

E.g. :

Input:

EmpNo, DeptNo, Sal
1234, 10,1000
1234,20,2000
1234,30, 3000
1234,40,4000
2345,10,100
2345,20,200
2345,30,300

Output:

Emp No, Dept_10_Sal,Dept_20_Sal,Dept_30_Sal,Dept_40_Sal
1234, 1000, 2000,3000,4000
2345,100, 200, 300,0

Here we have more than 500 columns like this Dept_10_Sal, Dept_20_Sal........Dept_500_Sal.

View 32 Replies View Related

SQL & PL/SQL :: Get Single Row From Multiple Duplicate Values Of One Field?

Sep 10, 2012

CREATE TABLE prim_tbl
(id NUMBER,--- id is not primary key here
description VARCHAR2(30));

INSERT ALL
INTO prim_tbl VALUES (1,'aad')
INTO prim_tbl VALUES (1,'aads')
INTO prim_tbl VALUES (2,'bb')
INTO prim_tbl VALUES (2,'cc')
INTO prim_tbl VALUES (2,'dd')
SELECT * FROM dual;

I want to select the ids only one time, i.e my output will have only two rows: one row with id as 1 and other row with id 2 whatever be the description.

desired output sample:

Quote:1, aad
2, bb

I used:
select distinct(id),description from prim_tbl;

but it did not give the required result.How can I get it??

View 6 Replies View Related

Summarizing Over Multiple Columns Aggregated On Grouping Field

Aug 9, 2011

I have spent the past hours trying to come up with a query to get the following starting table to the required result table.

STARTING TABLE:

PCD TEL

A 1
A 2
A 3
A 4
A 5
B 2
C 3
C 4

REQUIRED RESULT:

PCD TEL1 TEL2 TEL3 TEL4

A 1 2 3 4
B2 NULL NULL NULL
C 3 4 NULL NULL

View 1 Replies View Related

SQL & PL/SQL :: How To Parse Rows In Different Columns

Apr 29, 2011

I have a table that has rows like below in one column. I want to parse the rows in different columns.

Column12

abc|yed| qas ert | hub cap | jak
agh|
bef|rfd
som|gfr|lup

I need to parse the above in different columns by splitting at the pipe.

so it will show something like this

col1 col2 col3 col4 col5
abc yed qas ert hub cap jak
agh
bef rfd
som gfr lup

is it possible to do it in PL/sql.

View 3 Replies View Related

SQL & PL/SQL :: How To Parse Data And Add Columns In A View

Jan 11, 2012

I have a column which holds the data in the below format.

Source Data :
>SNO_SDSDQ-8192-BN>SNO_54-99-24120-8192
>SNO_SDSDQ-8192-BN>SNO_54-99-24120-8192>SNO_54-90-16489-008G
>SNO_SDPMDB-008G-11>SNO_54-90-18008-008G>SNO_54-62-08791-008G>SNO_20-81-00327
>SNO_SDPMDB-008G-12>SNO_54-90-17830-008G>SNO_54-62-08598-008G>SNO_20-81-00327

[code]..

Problem Statement :
Split the above data into individual components and create columns / aliases dynamically.If the column is present then place the data under the created column.

Example 1) :
>SNO_SDSDQ-8192-BN>SNO_54-99-24120-8192

Result
Column Name : SKUCol_54-99
Data :SNO_SDSDQ-8192-BNSNO_54-99-24120-8192

Example 2)
>SNO_SDSDAA-002G-101-J>SNO_54-90-16002-002G>SNO_54-62-05781-002G>SNO_20-81-00135-5

Column Name : SKU54-90Col_54_62Col_20_81
Data :SNO_SDSDAA-002G-101-JSNO_54-90-16002-002GSNO_54-62-05781-002GSNO_20-81-00135-5

Column Name can be derieved from the components like SNO_54-62-05781-002G

i.e. SNO_54-62-05781-002G ==> SNO_-05781-002G
"54-62" will give the Col_Name

The First Column will always have data starting with
SNO_SD%
This column is constant and will be named as SKU.

I need this data to be placed in the same record / row but under different columns as per the data set.Basically, Can the data be split into multiple parts based on delimeters and the columns are created based on the unique data in the parts that form the data in the column.

View 1 Replies View Related

Soft Parse In Instance Efficiency Is 11.21%

Jun 20, 2013

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.19 In-memory Sort %: 100.00
Library Hit %: 83.82 Soft Parse %: 11.21
Execute to Parse %: 92.47 Latch Hit %: 99.77
Parse CPU to Parse Elapsd %: 82.07 % Non-Parse CPU: 71.64

I see my soft parse in instance efficiency is 11.21%. Is this something to worry about?

View 2 Replies View Related

XML DB :: Parse XML File And Extract Data

Jul 22, 2013

I'd like to parse an XML file and get some data extracted as columns. Input file country.xml:

<?xml version="1.0" encoding="UTF-8"?>
<MAS Action="Insert">
<Country ObjectId="100000000000000009" VersionId="8"><Id>1</Id><NlTexts><Name Language="de">Land1</Name><Name Language="en">Country1</Name></NlTexts></Country>

[Code]....

View 2 Replies View Related

PL/SQL :: Oracle 9i Extract / Parse XML From BLOB

Sep 26, 2013

I have table with Blob column. In the blog column I have XML data (see below).  I wanted to parse xml and get the value of note '<GetTest>'. How do I achieve that? Sample Table:

create table SAMPLE_XML_TABLE
(
  ID           NUMBER not null,
  XMLSTRING    BLOB,
);  
<?xml version="1.0" standalone="no"?>
<FromResponse xmlns="http://www.somewebsite.com/FromResponse">
<Code>0000</Code>
[code]......... 

View 7 Replies View Related

Select Multiple Images Using Department Field In Spriden Table To Pull Needed Id Numbers

Jan 29, 2009

I have an Oracle 10g database, on the App Serv I have an image file that has 20,000 .jpg files that has an id number as each image name.I have successfully queryed the image file and posted one image to my web page matching the image id number.
sample:

select substr(spriden_last_name,1,20)||', '||
substr(spriden_first_name,1,20)||' '||
substr(spriden_mi,1,1) stname,
'<img src = "/images/&1..JPG" width="400" height="400"/>' pic
from spriden
where spriden_id = '&1'
/

the &1 is the matching id number that is input from the user.My task now is to select multiple images using a department field in the spriden table to pull the needed id numbers.I have not been successful in the proper format to pass the id number to the <img src field.

View 4 Replies View Related

JDeveloper, Java & XML :: Parse Automatically By Tree?

Apr 11, 2011

I got the table where are logged every single events from web site. Sometimes (depends on events)is written xml code into the xml_params column of table H ow to make an automatically procedure (sql query, function, or something like that) which every value of xml code should be written separate into the column the table. The point is I dont know what parameters will be included in the xml code in future.

For instance xml looks like:
<parameters xmlns="http://datalan.sk/webreporting/params/v1_0">
<parameter name="loginReason">
<value>invalidUserNameOrPassword</value>

[code]....

View 17 Replies View Related

Forms :: How To Parse Paramlist Type Variable

Mar 22, 2010

how to parse paramlist type variable to get names of the fields and their values in the paramlist?

View 1 Replies View Related

Write Shell Script To Parse Parameter File

Mar 29, 2013

I'm working on trying to write a shell script to parse a parameter file, but at the same time I want to be able to overwrite the parameter file settings with other command line settings. For instance if my par file had export/import settings for the username, password, schema, etc;

I wanted to run the same export/import with those settings for a different schema. I want to be able to put the schema=<different_than_par_file> after the parfile=<parfile.par and have the parfile be read and applied for everything except the different schema.

Right now I'm storing the cmd line and parsing it again looking for other parameters besides the parfile.

View 4 Replies View Related

Server Utilities :: Field In Datafile Exceeds Maximum Length For Number Field?

Apr 23, 2010

Even though i am using COL1 CHAR(500) NULLIF COL1=BLANKS, then also i am getting same error for those columns.

View 13 Replies View Related

Forms :: Update Field Based On Another Field Checkbox

May 3, 2013

I have a table where i need to update one field values based on another field of the same table , simply as it is.I have done this using one select all check box , on clicking that all check boxes of item_trans table will get selected , then i will un select some of check box and then using one button, i will update the value of the fields which are checked only.

I have put the sample code but when i am updating its taking long time and hanging.I am also attaching the form based on the test case provided.

--tables with insert statement
create table item_trans (trans_item varchar2(12),trans_qty number,trans_act_qty number)

insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE1',40,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE2',20,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE3',20,NULL);

--i want to set the value of trans_Act_qty as trans_qty

--i create one dummy or test block to keep the select all check box. for that table test script is

CREATE TABLE TEST
(
C VARCHAR2(2000 BYTE),
B NUMBER,
A NUMBER
);

insert into test (C,B,A) values ('A',1,1);

--code written in select all check box which is created on test.block.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
:M_END_YN := :M_END_ALL;
[code].......

--code written in M_END_YN ( actual check boxes where i will uncheck).

IF :M_END_YN = 'N' THEN
:M_END_ALL := 'N';
END IF;

--code written on button to update those values which are checked.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
IF :M_END_YN = 'Y' THEN
[code]......

View 5 Replies View Related

How To Enable And Disable A Field Dependent On Another Field In Apex

May 9, 2013

I am New to Apex. Im using Apex Version 4.2.

I have a tab named APPROPRIATIONS it has 10 fields. Among which is PROJECT NUMBER, AUTHORIZAION DATE (CALENDER TYPE POPUP), And FUNDS CHECK FLAG.

The Scenario is depending upon PROJECT NUMBER the Fields are Populated including FUNDS CHECK FLAG .

But the AUTHORIZAION DATE is a MANDATORY field has to be filled by User

The Requirement is to make AUTHORIZAION DATE as MANDATORY only when the FUNDS CHECK FLAG is *"BLANK "* or *“Y”*

If the FUNDS CHECK FLAG is *“N”* then the AUTHORIZAION DATE to be made OPTIONAL.

View 2 Replies View Related

Update Field With 1st 9 Characters Of Another Field In Same Record?

Apr 23, 2009

I need to update a field with the 1st 9 characters of another field in the same record.

View 1 Replies View Related

SQL & PL/SQL :: Updating A Date Field With Field From Another Table?

Nov 14, 2011

I have a table called Customer_Type with following fields

Customer_type ,Active_date, Inactive_date
regular,11/01/2011
daily,11/04/2011
monthly,11/05/2011/11/11/2011

Tbale 2:Customer

Customer_name,Customer_type,Customer_Inactive_date
John,regular,
James,monthly,
Jake,daily,
Jill,monthly

What i wnat is to update the Customer_inactive_date with the Incative_date field from Customer_type based on their Customer_type... So james and Jill would have their rows updated in this scneario ..How can i achive this in pl/Sql

I have teh code using merge function..I want something in traditional old fashion..

The sql statements are below

CREATE TABLE CUSTOMER_TYPE
(
type_code VARCHAR2(10),

[Code]....

View 5 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 :: 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 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







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