Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 14th, 2011, 07:47 AM
Authorized User
Points: 350, Level: 6
Points: 350, Level: 6 Points: 350, Level: 6 Points: 350, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2008
Location: , , Pakistan.
Posts: 54
Thanks: 8
Thanked 1 Time in 1 Post
Default How to separate two functions in a query? Except this || ' -- '||.

How to separate two functions in a Oracle query?
What else can be used other than || ' -- '|| to use more than one function in a query?
For e.g.:SELECT RTRIM(ACC_ID) || ' -- '|| length (acc_id) from tbla;
as RTRIM and LENGTH are functions so there has to be something in between like || ' -- '||
for this query in order to run.
As below query which has nothing between RTRIM and LENGTH
SELECT RTRIM(ACC_ID) length (acc_id) from tbla;
Gives ERROR:'FROM keyword not found where expected'


Thanks in Advance.
__________________
How to do programming?
  #2 (permalink)  
Old March 14th, 2011, 08:13 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

I'd have thought a comma:
Code:
,
__________________
Joe
http://joe.fawcett.name/
The Following User Says Thank You to joefawcett For This Useful Post:
arbab (March 15th, 2011)
  #3 (permalink)  
Old March 15th, 2011, 03:34 AM
Authorized User
Points: 350, Level: 6
Points: 350, Level: 6 Points: 350, Level: 6 Points: 350, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2008
Location: , , Pakistan.
Posts: 54
Thanks: 8
Thanked 1 Time in 1 Post
Default I was trying 'Comma' with a wrong column name

Thank you, I was trying 'Comma' with a wrong column name, that's why I was having error.

Thanks for your guidance.

__________________
How to do programming?
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Separate user tables? Clint PHP Databases 3 May 11th, 2012 06:06 AM
How to separate double number draganp71 Visual Basic 2008 Essentials 2 April 27th, 2010 04:11 AM
separate a string with whitespace petergoodman XSLT 8 July 8th, 2008 01:56 AM
Two separate menu from one sitemap? KieshaJ310 ASP.NET 2.0 Basics 5 July 4th, 2007 01:31 AM
Search separate C from CR topshed Classic ASP Databases 2 December 29th, 2005 08:58 AM



All times are GMT -4. The time now is 04:56 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.