column name cancatenation within PL/SQL


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

I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lname like "'%"||p_lname||"'"

It keeps giving me syntax error: ora-00904: invalid identifier ...

any suggestion?

No comments posted yet

Your Answer:

Login to answer
200 Like 18 Dislike
Previous forums Next forums
Other forums

HTML Email rec'd as Source Code
The code does create and send the email successfully. However, the message shows as html code and n

user data not transferring to new page
I'm a PHP learner. After an index.php page, the user goes to a login.php page. Both pages seem to

How to get the previous months last date....
Here's my wittle problem. I suck at working with dates.

So today is 10/20/2009, i need to fig

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_

weeks in a year
hi,

i found this snippet on php.net
QuoteFor the week number for weeks starting on Sunday:

passthru() help
Hi everyone,
I'm new to the forum and to PHP. I have some pretty good experience writing shell sc

unexpected T_STRING
error log "[Sat Jan 09 18:27:58 2010] [error] [client 127.0.0.1] PHP Parse error: syntax error

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

update 2 columns by doing inner 2-column query
Hi,
is something like this possible?

update contract_all set col1,col2 =
(

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