I want to create a table type that should have more than 1024 columns. So I tried to use sparse columns by creating a – SpecialPurposeColumns XML COLUMN_SET as shown below. That did not work. It gave me an error: Incorrect syntax near ‘COLUMN_SET’ Is there any way that I can create a table t…
Tag: user-defined-types
What is the difference in select with alias, and without- oracle 11g
I have a table, let’s name it table1. The table consists of many columns, and one of the columns is an object, which consist of 3 subcolumns, let’s call them value1, value2, value3. Let’s say that …
How to create a collection and insert values in a table with the collection?
Hey I am creating a database to store some information about a sport club, where I have trainers and athletes, but when I am trying to insert trainers(entrenadors) to the table that errors appears: …
Assign Data to a User-Defined Table type from Select Query?
I have a stored procedure which retrieves three columns from multiple tables. I want to get the results in a user defined multi-valued table and pass the variable to another procedure to perform operations on the variable data. However it is not working. Any idea why it this not working? Answer The problem is…
How do I create Oracle Type which refers to table columns for data type?
I am trying to define a type using the following code. If I run this, I get the error. What is wrong with this? Answer What’s wrong with it is that %type is PL/SQL syntax. It isn’t supported in SQL. Now we use PL/SQL to define Types (especially member functions, constructors, etc) but the Types th…