Home » SQL & PL/SQL » SQL & PL/SQL » question regarding the data type (Oracle 9i/10g)
question regarding the data type [message #433745] Fri, 04 December 2009 00:15 Go to next message
ktanya
Messages: 10
Registered: July 2007
Junior Member
Hi,
I got the following interview question
4. If I have get input data in different forms like:

Form1:
1, 2, 3 A, B, C

Form2:
1A, 2B, 3C

Form3:
1A
2B
3C

How would I design this type of data.

It would be interesting to know the correct answers because I thought about the collections for the first two forms and sys refcursors for the third form.
thank you.


Re: question regarding the data type [message #433752 is a reply to message #433745] Fri, 04 December 2009 00:53 Go to previous message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This question is simply meaningless.
First try to explain what it means.
What is the actual data? A string or 3 strings?

Regards
Michel
Previous Topic: Escape Single Codes in Dynamic Script
Next Topic: using AND conditon in select statement
Goto Forum:
  


Current Time: Sat Sep 24 19:49:26 CDT 2016

Total time taken to generate the page: 0.08834 seconds