Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Understanding Concat Function
This is a discussion on Understanding Concat Function within the SQL forums, part of the Databases category; Hello i'm a new member i 've just began to learn SQL and I want to understand this request thanks Select 'BE.'||:global.code_mag||'.'||to_char(sysdate,'RRRR')||'.'||lpad(nvl(count(*),0) + 1, 6, 0)...
|
|||||||
10-12-2009
|
|||
|
|||
|
Understanding Concat Function
Hello i'm a new member
i 've just began to learn SQL and I want to understand this request thanks Select 'BE.'||:global.code_mag||'.'||to_char(sysdate,'RRRR')||'.'||lpad(nvl(count(*),0) + 1, 6, 0) 
|
| Sponsored Links |
|
10-12-2009
|
|||
|
|||
|
Re: Understanding Concat Function
it simply concatenates the results of column data , function output and some static value.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| AJAX Made Easy - Understanding XML Signature | Lokesh M | AJAX & XML | 0 | 05-23-2009 01:10 AM |
| How to configure php mail() function in Apache server and how to use mail() function. | yusuf456 | PHP | 0 | 04-02-2009 05:49 AM |
| Understanding of Tabs in Test Director | here4u1979 | Test Director | 1 | 03-09-2009 03:56 AM |
| AJAX Made Easy - Understanding Cross-Site Request Forgery (CSRF) | Lokesh M | AJAX & XML | 0 | 02-05-2009 03:50 AM |
| understanding imports | Peruano | Java | 0 | 11-02-2007 02:10 AM |
All times are GMT -4. The time now is 05:32 PM.
