Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.
0
votes
0answers
7 views
inconsistent datatypes when comparing two varrays in where clause
I am trying to filter a SQL query by putting a where clause where the a set of varrays returned is compared to see if it equals a single varray from another select statement, but when I run it I get ...
1
vote
1answer
35 views
Does storing date without time use less bytes?
I saw this link and this:
If you specify a date value without a time component, then the default
time is midnight. If you specify a date value without a date, then the
default date is the ...
0
votes
0answers
10 views
String was not recognized as a valid Boolean. - an Error Related to C#. GridView CheckBoxField
Here is the programming environment.
Framework: ASP.NET Framework 4
Language: Visual C# 2010
Database: Oracle Database 11g
Here is the scenario.
I'm creating a GridView from the HR Sample ...
0
votes
1answer
45 views
how to reduce the Procedure time in oracle which is running based on Cursor for loop?
How can I reduce the time of the procedure? Now it is taking 7 minutes to completed, I am using Cursor for loop in my report to loop around the 400 employees (using Cursor for loop) for 30 days ...
0
votes
0answers
22 views
Oracle trigger error, 10g to 11g export
i am trying to export a 10g database to 11g and receieving error(execution completed with warning) at the row that tries to create the trigger.
...
0
votes
0answers
15 views
How to resolve this error in oracle? [closed]
I have tried this
public ViewResult Index()
{
var allocations = new PagedData<ALLOCATION_M>
{
Data = _db.ALLOCATION_M.OrderBy(a => a.ALLO_ID).Take(PageSize)
...
0
votes
1answer
29 views
Oracle - View function body from a package
I have a function inside of a package in Oracle and am wanting to view the implementation or the body of one of the functions.
I can find the package in the all_source view but cannot find the ...
1
vote
1answer
22 views
SQL Retrieving varray elements of a subobject in Oracle 11g Database
I am building a SQL query of a database where I am trying to retrieve an element of a VARRAY that is a subobject of several objects that is an element of another VARRAY. I can successfully query ...
0
votes
1answer
21 views
Why is the error ORA-01008 appearing?
I´ve got a query in spring integration that it´s mapped but when I run my query I get the error: ORA-01008 not all variables were bind.
Here is my spring integration code:
<bean ...
1
vote
0answers
28 views
ASP Retrieving a trigger-populated field value - worked with earlier version of Oracle
The below sample ASP classic code that I have modified so it can be run via cscript or wscript, communicating with Oracle 8i and using Oracle ODBC Driver 8.01.07.00 running on Windows 2000, returns a ...
0
votes
1answer
36 views
SQL Retrieving an object from VARRAY in Oracle 11g Database
I have a schema RTRD_W built in an Oracle 11g database that contains a table rtrd_pri that has a column NOMNL which is has a type defined as VARRAY(10) OF KPS_ADM.NUMBER_T (an object defined as a ...
2
votes
2answers
37 views
Replicating Excel's CHIDIST function in Oracle 11g
I'm attempting to replicate the functionality of an Excel workbook in Oracle. One of the formulae on the worksheet uses CHIDIST, which "Returns the one-tailed probability of the chi-squared ...
0
votes
1answer
39 views
Oracle convert DECODE to PIVOT or force use of index
I have a very complex SQL view definition that has been inherited and requires altering to improve performance. It takes a list of records based on a foreign key and displays the rows returned as ...
0
votes
1answer
15 views
Bind Variable Oracle DB - R
I'm working on some R-scripts which require the use of database queries. My IT department mentioned to me that these scripts require too much of the database (shared pool) and I should use ...
0
votes
1answer
24 views
how i'm going to include connection file in vb.net?
i'm using vb.net and oracle.
this is my code connection with db
Dim connectionString As String = "Data Source = abc; User ID = abc; Password = abc;"
Dim sqlConnection As ...
