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 ...
Did you know?Explore Trending and Topic pages for more stories like this.

any suggestion?
No comments posted yet

Your Answer:

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

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit

set xml path in flash when xml created in memorystream and webrequest
i am creating an xml file using memory stream and i want to load this xml file into the flash on cli

Multi dimensional arrays
If I put in this code:

1
2
3
4
5
6
7
8
9
10
11
12
13<

Help with form post data and arrays
Hi all,

I am new to this forum... It has been awhile since i have worked with arrays, and i a

limit string by words??
hello all,

I was wonder if there is a function to limit a string by the number of words inste

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

Why use OOP?
Can someone explain to me why I should use OOP instead of procedure based code.

Im building a

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