Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Newbi
Starting Member
5 Posts |
Posted - 2013-06-12 : 05:01:32
|
HI All,I am newbie with pl/sql and sql..I want to know that which of the following allows a pl/sql user to define a function?1-Alter table command2-Having clause of the select command3-From clause of the select an update command4-nextvalkindly tell me with brief description....ThanksAbbas |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-06-12 : 05:07:28
|
PL/SQL related to ORACLE...This forum is purely for SQL Server.... Here we deal with T-SQL...As per ANSI standards, Functions doesn't allow any UPDATE, ALTER and etc functionalities....I think answer should be 2 ( we can use SELECT statement along with HAVING clause in a function) --Chandu |
|
|
Newbi
Starting Member
5 Posts |
Posted - 2013-06-12 : 05:12:30
|
thnaks chandu......Abbas |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-06-12 : 05:19:07
|
quote: Originally posted by Newbi thnaks chandu......Abbas
What about 4th option...?Check once in the ORACLE BOX Create function to return sequence's nextval then you will get to know the result....And also google it--Chandu |
|
|
|
|
|