OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » pl/sql problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pl/sql problem [message #265854]

Fri, 07 September 2007 11:45

ashish2345
Messages: 50
Registered: September 2007

Member

I use oracle9i. i encountered a problem in which i was to check the validation that a column is autogenerative or not.

secondly how can we return a table through procedure or function
thirdly if i am asked to return only one value from function how can ireturn two taking as one. is it using record. if yes please tell

thanks
ashish

Report message to a moderator

Re: pl/sql problem [message #265858 is a reply to message #265854]

Fri, 07 September 2007 12:01

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Say what you already tried, you don't do homework, we just help you.

Regards
Michel

Report message to a moderator

Re: pl/sql problem [message #265862 is a reply to message #265854]

Fri, 07 September 2007 12:04

ashish2345
Messages: 50
Registered: September 2007

Member

simply i cannot check autogenerative part .
i tried to return two values by concat function and returning in1 but that stores only two same varchars not one number and varchar

Report message to a moderator

Re: pl/sql problem [message #265872 is a reply to message #265862]

Fri, 07 September 2007 13:06

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What do you mean "autogenerative part", there is no autogenerate something in Oracle.

Quote:

i tried to return two values by concat function and returning in1 but that stores only two same varchars not one number and varchar

Copy and paste what you tried.
Explain clearly what you want to achieve, the same way you'd do it to your mother.

Regards
Michel

Report message to a moderator

Previous Topic:	Doubt in OCA Certification
Next Topic:	OLAP Introduction

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 19:02:33 CDT 2024