Say I have created some user-defined types in the DB, i.e. CREATE TYPE abc ... Is it then possible to determine if the user-defined type exists or not? Perhaps, using any of the postgres informa...

After many years of using C++ I realized a quirk in the syntax when using custom classes. Despite being the correct language behavior it allows to create very misleading interfaces. Example here: c...

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

I have a question about User-Defined Table Types in SQL Server 2008. For the need of one of the ASP.NET application we defined our own table-types on SQL Server 2008 to use them as parameters in t...

I have a table in SQL Server. I want to bulk upload rows into this table using a user-defined table type (example here). To do this, I need to create a user-defined table type with the same format ...

What is the python way to define a (non-class) type like: typedef Dict[Union[int, str], Set[str]] RecordType

Couldn't seem to find a definitive answer. I want to do a type hint for a function and the type being some custom class that I have defined, called it CustomClass(). And then let's say in some func...

i have a type as follows: CREATE OR REPLACE TYPE tbusiness_inter_item_bag AS OBJECT ( item_id NUMBER, system_event_cd VARCHAR2 (20), CONSTRUCTOR FUNCTION tbusiness_inter_item_bag RETURN SELF AS...

The docs say that a class is hashable as long as it defines __hash__ method and __eq__ method. However: class X(list): # read-only interface of `tuple` and `list` should be the same, so reuse tup...

The data access layer in our application is going to be using the UDT functionality of Oracle. We will only be passing UDT objects to and from the database. At the moment, we generate the custom c...

I have a stored procedure with 3 input paramaters. ... PROCEDURE [dbo].[gama_SearchLibraryDocuments] @Keyword nvarchar(160), @CategoryIds [dbo].[IntList] READONLY, @MarketIds [dbo].[IntList] REA...

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 tha...

I Think I am currently experiencing a bug in Entity Framework 6 and possibly ADO.NET. Since there is a deadline I am not sure I can wait for this bug to be fixed and hopefully someone can help me w...

I have implemented java.sql.SQLData in order to bind UDT objects to prepared statements using ojdbc6. Now, some of my UDT's contain arrays. What I need to do now is this: class MyType implements S...

When I try to compile the procedure with collection type as in parameter, I'm getting the error like wrong number or types of arguments in call to 'P_AA' -------Procedure created with in para...

I'm making a custom Hibernate type using AbstractSingleColumnStandardBasicType to automatically convert the SQL UDT into a Java type. The SQL uses database functions to construct and serialize the ...

I have an array of strings. I want to check if a particular string is present in the array. DECLARE TYPE v_array IS TABLE OF VARCHAR2(200); ais_array v_array; BEGIN ais_array := ('Lb1','Lb2','L...

In Spark 2.0, the one example I've found of creating a UDT in Scala seems to no longer be applicable. The UserDefinedType class has been set as private, with the comment: Note: This was previou...

I defined my Int type as int. I want to convert a slice of Int to a slice of int, but got a compile error: cannot convert c (type []Int) to type []int How can I fix this? package main import ( ...

So for any built-in types in Haskell, I can construct an arithmetic sequence, like this one (for Int or Integer, etc.) [1..5] But if I define an enum type like: data Suit = Club | Diamond...

What is the main purpose of using collections in oracle ? Index by tables Nested tables Variable size ARRAY Can you please explain the difference between the above types of collections ?

I have been attempting to test out an insert of a Cassandra UDT, and i keep running into the following error: Exception in thread "main" java.lang.IllegalArgumentException: UserTypeResolver must no...

Is it allowed to overload operators, such as operator+ for a combination of a standard library type and a built-in type, when such an overload doesn't exist? For example, is it legal to implement ...

This link shows how to get a procedure/function variable's type in Oracle: View Type of a variable. It does so through the function "get_plsql_type_name": create or replace function get_p...

I'm trying to pass my User Defined Table Type to a store procedure (originaly using EF). However, I'm stuck, because it looks like sp_executesql passes the parametr to the stored procedure, but its...