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

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

pass form variables straight to email, no database required?
hello all,

im working on this form...

http://www.adobedayevents.com/project_request/pr

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

pointer 102 question
I read a book
1
2
3
4
5
6
7
8
9
10
11
12
int main() {

onclick problem
I have <input type="text" name="message">
<a href=page2.

Need help with PHP/MySQL drop down menu
I need help on how I can implement a drop down menu which queries mysql database and output the avai

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

Sales orders ans reservations not taken into account on MPS / MRP
Hello,

I am implementing the MPS / MRP and I have the following problem:

I ha

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