-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Process Flow is a very important component of Oracle Warehouse Builder. With Process Flow, we can create and control the ETL process by setting all kinds of activities in a well-constructed flow. In Oracle Warehouse Builder 11gR2, there are 28 kinds of activities, which fall into three categories:…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Suppose I have a user defined type:
CREATE OR REPLACE TYPE TEST_TYPE AS OBJECT
(
f1 varchar2(10),
f2 number(5)
);
Now, I want to create a table to hold these types. I can do the following:
create table test_type_table (
test_type_field test_type
);
This gives me a table with one…
>>> More
-
as seen on SQL Server Central
- Search for 'SQL Server Central'
To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying…
>>> More
-
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
User-Defined Functions
Scalar User-Defined Function
A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These are the type of user-defined functions that most developers are used to in other programming languages.
Table-Value…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Can someone please help me define what is "user defined domains" or refer me to some resources?
Thanks!
>>> More
