Splitting Attributes

Posted on 16th Feb 2014 07:03 pm by admin

SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, INSTR(I_NAME,'O')+1) "Second part"

FROM Enrollment

WHERE I_NAME like '%O%';
2 3 4

I_NAME First part Second part

--------------------
LIOU LIO U

I am just not sure why it’s only pulling one name from the table.

Your Answer:

Login to answer

Other forums

Email "$"
Hello!!

Any PHP guy with a bit of a knowledge in Flash ?

When I send a JPEG from flash

Developing Ajax-enabled ASP.Net applications for the iPhone
I would like to develop Ajax web applications using Visual Studio that are optimized for the iPhone.

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

Taking an HTML form and a PHP program and making it into one working file.
Hello,

So I would like to display everything INSIDE a specific directory. In other words, I

simple script won't work. Please help
I'm new to php, and I am having trouble displaying a simple script in my web browser. My php code ex

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

Sort Alternative/bi-monthly
Hi all,

Am going mad trying to get something to work.

I'm creating a CMS for a magazi