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

Career Change into SAP
Hai
I am sajesh ,did my diploma in Mechatronics i have a 4 years of experience in

COde for a Cc
I'm not receiving $ft as a Cc. Why is that??

$to = "$email";
$headers = "Fr

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma

Storing/displaying image urls in a database?
Hi
Basically I have the following scenario:
User chooses picture from list. Picture info is ad

Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I

PHP Code reffering to database, doing something wrong.. pls help
Well i am quite new with PHP
and for school we have to make a PHP script which reffers to a Data

Page not Loading After Test
Hey All

It seemed that an inlcude statement wasn't working for some reason, so I tried a more

Strange PHP/mySQL error ... am I just tired?
Code: <?

## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam

get the country of visitor and display content based on that
Hello all,

I have seen that Google analytics can tell you where a visitor is coming from and

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