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. |
pl/sql function
This is a discussion on pl/sql function within the Oracle Certification forums, part of the Certification category; i have created a function which takes two IN parameters(lets say x and y) of varchar2 type,retturn type is varchar2. this function concatenate two parametes and return the values which ...
|
|||||||
02-21-2007
|
|||
|
|||
|
pl/sql function
i have created a function which takes two IN parameters(lets say x and y) of varchar2 type,retturn type is varchar2. this function concatenate two parametes and return the values
which 2 are true 1.this function can be used against any table 2.this function can be used only if two parameters are passed in are not null values 3. this function will generate a sstring based on two character values passed into the function 4. this function can be used only on tables where there is a x and y colum 
|
| Sponsored Links |
|
02-22-2007
|
|||
|
|||
|
Re: pl/sql function
2,3 are right answers
|
| The Following User Says Thank You to smitai For This Useful Post: | ||
|
02-22-2007
|
|||
|
|||
|
Re: pl/sql function
Option 1 is correct
|
|
02-22-2007
|
|||
|
|||
|
Re: pl/sql function
Options 1 and 3 are correct....
1. yes you can use this function against any table 2. concatenate works with null parameters. So this option is wrong 3. obviously this statement is true 4. No. column names need not have to match with paramter name.
__________________
Cheers, :) James:)
|
| The Following User Says Thank You to jamesravid For This Useful Post: | ||
 |
|
«
-
|
can i get answer for this
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| TSL Function | sutnarcha | WinRunner | 1 | 12-20-2006 05:40 AM |
| SQL Function rawtohex() | nancyphilips | SQL | 1 | 07-30-2006 07:17 PM |
| Function in PHP | sripri | PHP | 1 | 07-20-2006 12:13 PM |
| Query with a Function in C | joel | C and C++ | 1 | 07-16-2006 12:33 PM |
| Memory Function in C | scott | C and C++ | 1 | 07-16-2006 12:24 PM |
All times are GMT -4. The time now is 09:53 AM.
