Tag Info

New answers tagged

2

There is absolutely nothing about this on the Internet - even the Oracle docs regarding the %_ASSEMBLIES views don't actually state what they show. However, if you go digging around in $ORACLE_HOME/rdbms/admin you'll see the following reference to the data dictionary views (which sit on assembly$: remark remark FAMILY "ASSEMBLIES" remark remark Views for ...


0

I think this page has what you are looking for - Assembly: Assembly is Microsoft's term for the module that is created when a DLL or .EXE is complied by a .NET compiler. If I understand it correctly it is the .NET equivalent for Java's "class files". Starting 11g, you can develop and deploy .NET procedures and functions in Oracle database. Here ...


1

Most likely ,(SELECT NVL (I.sap_xref_no, part_doc_nbr) FROM eissap.tbitem i WHERE i.item IN (SELECT comp_part FROM eissap.tbpart_config_comp_config WHERE item = comp_part)) AS sap_xref_no, returns more than one row (exactly as error says). When subquery is used in SELECT clause of ...


0

Take a look here - point 2 here (recipes for disaster), 2. We will check data integrity at the application level instead of taking advantage of Oracle's constraint checking abilities. Jonathan Lewis is the man for Oracle and indexes. If I were you, I would do something like (works in MySQL and PostgreSQL, don't have Oracle up and running at the moment). ...



Top 50 recent answers are included