Top "User-defined-types" questions

User-Defined Type (UDT) is a type that customize by user.

Altering user-defined table types in SQL Server

How can I alter a user-defined table type in SQL Server ?

sql-server user-defined-types
How to check existence of user-define table type in SQL Server 2008?

I have a user-defined table type. I want to check it's existence before editing in a patch using OBJECT_ID(…

sql sql-server sql-server-2008 tsql user-defined-types
Purpose of using different types of PL/SQL collections in Oracle

What is the main purpose of using collections in oracle ? Index by tables Nested tables Variable size ARRAY Can you …

oracle collections user-defined-types
Check if a user-defined type already exists in PostgreSQL

Say I have created some user-defined types in the DB, i.e. CREATE TYPE abc ... Is it then possible to …

postgresql user-defined-types
The EXECUTE permission is denied on the user-defined table types?

I have a question about User-Defined Table Types in SQL Server 2008. For the need of one of the ASP.NET …

asp.net security sql-server-2008 stored-procedures user-defined-types
User Defined Type (UDT) as parameter in public Sub in class module (VB6)

I've tried to solve this problem, but can't find any solution. I have a UDT defined in a normal module, …

vba vb6 user-defined-types
Type hints with user defined classes

Couldn't seem to find a definitive answer. I want to do a type hint for a function and the type …

python python-3.x types type-hinting user-defined-types
Oracle User defined type inside package definition

is it possible to have a User Defined Type inside Oracle package definition? When I try following CREATE OR REPLACE …

oracle stored-procedures plsql package user-defined-types
pl/sql object types "ORA-06530: Reference to uninitialized composite" error

i have a type as follows: CREATE OR REPLACE TYPE tbusiness_inter_item_bag AS OBJECT ( item_id NUMBER, system_…

oracle plsql user-defined-types
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. CREATE OR REPLACE TYPE MY_TYPE AS OBJECT ( app_…

sql oracle user-defined-types