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

Extra fields in main body and php required.
I'm new to PHP so please be gentle. I have a little php script below that works well.
The &quo

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,

Php Mysql Page Loading Notice
Hi all,

I was wondering if there is a way (Sure there is) of showing a message or an image wh

Big Problem!! Please help
Hi Guys,

Im making a website for a friend have encountered a really annoying problem. When ev

Forms Authentication and Refresh at Login page
Hello, When I try to press the Login button in my webapplication at my login.aspx page nothing h

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for

newbie question about multiple queries
hi everyone,
I'm sorry to ask such a basic question, but I'm young and trying to learn php on my

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.

However

Database/Table Collation
What is the Database, and table collations used for? i don't understand what there used for since co

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