Home » Other » Training & Certification » pl/sql problem
pl/sql problem [message #265854] Fri, 07 September 2007 11:45 Go to next message
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
Re: pl/sql problem [message #265858 is a reply to message #265854] Fri, 07 September 2007 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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
Re: pl/sql problem [message #265862 is a reply to message #265854] Fri, 07 September 2007 12:04 Go to previous messageGo to next message
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
Re: pl/sql problem [message #265872 is a reply to message #265862] Fri, 07 September 2007 13:06 Go to previous message
Michel Cadot
Messages: 68704
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
Previous Topic: Doubt in OCA Certification
Next Topic: OLAP Introduction
Goto Forum:
  


Current Time: Mon Nov 04 12:06:06 CST 2024