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.

No comments posted yet

Your Answer:

Login to answer
347 Like 47 Dislike
Previous forums Next forums
Other forums

Output Buffering question
Hi all,

I've been trying to wrap my head around output buffering. So far I've found tons of

Date Format
Hi there,

I have a date format like this right now:
Sat, 17 Oct 2009 17:04:00

I ne

Error in SQL Syntax HELP!!!
I have this page:

Code: <?php

session_start();

//connect to server and s

Must-Know Topics of PHP
Can you guys list the must-know topics of PHP. I am still a learner and I am trying to cover most of

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!

My son

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i

problem with array - multilingual page
this is my test page :
Code: <?php
if(isset($_GET['lang'])) {
if($_GET['la

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash