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?

Your Answer:

Login to answer

Other forums

Forum tutorial
Im a beginner in PHP. Im making a forum(previous questbook, counter and few others) to learn. For no

understanding functions and classes
Code: [Select]
class person {
var $name = "Jimmy Goe";

function get_nam

disable all input buttons
Hello Friends,

suppose i do have a file ( file.php ) has a submit button

Code: [Sele

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

some query on multilingual website
Hi all,

Which is the simplest and easiest method to make a website multilingual,
is it put

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

I have a parse error in this query help..
Code: $query1="INSERT INTO `rating` (`item_name`, `rating`, `ip_address`, `date_rated`) VALUES

Date Format
Hi there,

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

I ne