---
title: Accessing values from the left hand side of an APEX Shuttle
description: In APEX, the value of the shuttle item is a colon delimited string representing the contents of the right-hand side.
---

[DSP Blog ](https://content.dsp.co.uk)

# [Accessing values from the left hand side of an APEX Shuttle](https://content.dsp.co.uk/accessing-values-from-the-left-hand-side-of-an-apex-shuttle)

 Written by [Matt Mulvaney](https://content.dsp.co.uk/author/matt-mulvaney) | 20-May-2015 14:05:44

In [APEX](https://www.dsp.co.uk/oracle-apex-services), the value of the shuttle item is a colon delimited string representing the contents of the right hand side.

Consider a shuttle: P1_SHUTTLE below created from the following SQL

<https://content.dsp.co.uk/hubfs/Imported_Blog_Media/code1-hi1.png>

<https://content.dsp.co.uk/hubfs/Imported_Blog_Media/shuttle-hi.png>

When you ask for the value of :P1_SHUTTLE you get a colon delimited string of the Right Hand side (e.g. **7782:7566:7934:7844:7876:7698:7900:7839:7788:7521**)

To obtain the left hand side, on submit, the following steps are required:

1. Ensure the Shuttle uses a Named LOV; in the below example we are going to use a Shuttle called :P1_SHUTTLE and a Named LOV of “LOV_EMP”
2. Create a “On Submit – After Computations and Validations” Process with the following code
3. Change the LOV/Items names as appropriate

<https://content.dsp.co.uk/hubfs/Imported_Blog_Media/code2-hi1.png>

The above code uses local variables to store the colon delimited strings although you may choose to perform a custom process with the shuttle results.

The SQL consists of:

The LOV rendered as a HTML Select List with the Return Item Extracted through XML functions and converted to a table  
MINUS  
The Shuttle Right Hand Side rendered as a table

So basically, the left hand side is “what can be chosen minus what has been chosen”

The results of the above are then aggregated in to a single colon delimited string representing the shuttle left hand side (e.g. **7369:7499:7654:7902**)

For more information, check out our [Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services), and if you liked this blog, check out our other [APEX blogs here](https://content.dsp.co.uk/apex).

[Contact us](https://www.dsp.co.uk/contact-us) today and one of our expert developers will be in touch.

 

 

**Author**: [Matt Mulvaney](https://content.dsp.co.uk/apex/author/matt-mulvaney)

**Job Title**: Senior Oracle APEX Development Consultant

**Bio**: Matt is an experienced APEX solution designer having designed numerous complex systems using a broad range of Oracle Technologies. Building on his previous experience of Oracle Forms & PL/SQL, he is entirely focused on providing functionally rich APEX solutions. Matt promotes APEX as a software platform and openly shares best practises, techniques & approaches. Matt has a passion for excellence and enjoys producing high quality software solutions which provide a real business benefit.

 

 

[View full post](https://content.dsp.co.uk/accessing-values-from-the-left-hand-side-of-an-apex-shuttle)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Matt Mulvaney"
  },
  "dateModified" : "2025-09-18T09:25:30.567Z",
  "datePublished" : "2015-05-20T14:05:44Z",
  "headline" : "Accessing values from the left hand side of an APEX Shuttle",
  "image" : {
    "@type" : "ImageObject",
    "height" : 94,
    "url" : "https://www.dsp.co.uk/hubfs/Imported_Blog_Media/code1-hi1-1.png",
    "width" : 175
  },
  "mainEntityOfPage" : "https://content.dsp.co.uk/accessing-values-from-the-left-hand-side-of-an-apex-shuttle",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://content.dsp.co.uk/hubfs/Logos/DSP/DSP-logo-2019-150px.png",
      "width" : 58.44156
    },
    "name" : "DSP Blog"
  }
}
```