Questions tagged as 'oracle'

Tagged questions
1
answer

I can not get a provider for Oracle with Code First

I'm doing the following: Model dou Add folder > New Item follows images ThenIselectADO.NetEntity,giveitaname,andADD SelectCodeFirstandgiveNext Wellatthisstep,Iselect,andseefromtheimagethatIdonothavetheOracleClientoptionandIalreadyaddediti...
asked by 05.11.2015 / 13:14
1
answer

Simple example of how to generate an XML file in Oracle

One would have a simple example of a PLSQL Procedure (or documentation location) to generate an XML file based on a Schema (xsd), the data would be generated from an SQL query. In fact files from the RPS of ANS (National Health Agency BR).     
asked by 03.02.2016 / 21:31
2
answers

Limit size of VARCHAR2 field in Oracle

I have a column with type VARCHAR2 (4000 CHAR) and I am testing the size limit of the VARCHAR2 field in Oracle. I thought there was a limit of 4000 bytes in the field, even specifying the value 4000 in characters, because that...
asked by 08.07.2016 / 20:26
1
answer

Call PL / SQL procedure with collection of objects

Consider the following types: CREATE TYPE meu_tipo AS OBJECT ( meu_id NUMBER(6), meu_nome VARCHAR2(200) ); CREATE TYPE meu_tipo_tabela AS TABLE OF meu_tipo; And the following package: create or replace package pkg_test is...
asked by 03.12.2014 / 14:22
5
answers

What is the difference between comparison operators in Oracle?

In Oracle there are several operators to make comparisons of "different", such as: <> ¬= != ^= Example: Select * from tabel where nomeTabela <> 's'; Select * from tabel where nomeTabela != 's'; Select * from tabel where nomeTa...
asked by 30.10.2017 / 13:58
2
answers

When is it worth to pay for SQLServer or Oracle?

Open-source databases such as MySQL and Postgres are so advanced that they can handle a wide variety of applications without problems, perhaps most. (There's SQLite too, but this is more for when portability is essential.) But for business ap...
asked by 18.06.2014 / 13:32
1
answer

Maximum size for database tables

What can be the maximum size that a table can have? To be clearer: a table in MySQL, what is the maximum size it supports? And in SQL Server, Oracle, PostgreSQL?     
asked by 07.07.2016 / 20:17
3
answers

What is the purpose of the MINUS command in oracle?

I've never seen this command before and I also do not find it around here, I do not know if it has a different name and because of the Oracle documentation, I can not understand exactly how it works. I just want an explanation and a simple examp...
asked by 12.06.2015 / 20:12
3
answers

ASP.NET MVC5 - Asynchronous Methods on the Controller

I'm developing an MVC layer for an ASP.NET system written initially in WebForms. It does not use EntityFramework, so a good part of the system I had to work out a homemade solution. In order to use Ajax's asynchronous methods with the MVC5 Co...
asked by 26.02.2014 / 20:14
2
answers

Data Modeling: Integrity vs. Performance

In the company I work for, there is a data architecture I've never seen before, and I wonder if this is common, or if it's a new market trend. Just to mention the bank is Oracle. Here are some points: There is almost no relationship between...
asked by 03.05.2018 / 16:36