Hey Everyone. I'm a MS Dev, thats been asked to do some Oracle work.. It's not a problem really, but I'm running into a problem trying to understand how the Declare Type Table works.
If anyone would have the time to show me how this would work, I would appreciate it. We'll say we have a simple query: Select Name, Phone, Address1, City, state from tblAddress; We will also say that: Name is a varchar(20) Phone is a varchar(10) Address is a varchar(25) City is varchar(25) State is char(2) So... With these pieces of information, How would I Declare a Table for use inside of a procedure? Hopefully this will help me understand how the syntax works for the Declare Table type. Also, if anyone knows of any information that I might be able to read/skim up on, i'd appreciate it. ~Dan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
