Oracle Server is a relational DBMS (Database Management System) created by Oracle Corporation. Do NOT use this tag for other DBMS servers owned by Oracle (for instance MySQL, TimesTen and Berkeley DB).
0
votes
0answers
6 views
Oracle Tablespace Size Increment
How to increase the size of table space post its max limit. if the max limit is defined as 100M and still later I need to increase it. I have written a query consisting of max size of 100M and now i ...
1
vote
2answers
23 views
How to INSERT a DATE using Oracle MySQL
Hi I am new to MySQL and forgot how to enter a date. I have tried many variations and can't seem to get it, plus I have looked on the internet but can't find the correct example. My table is set up ...
2
votes
1answer
14 views
convert oracle trigger to ms sql trigger
I have an oracle trigger:
CREATE OR REPLACE TRIGGER "BI_Info"
BEFORE INSERT ON "Info" FOR EACH ROW
WHEN (NEW."Id" IS NULL OR NEW."Id" = 0) BEGIN
SELECT NVL(MAX("Id")+1, 1) INTO :NEW."Id" FROM ...
-1
votes
1answer
23 views
Foreach loop to see result in Rich text box but only seeing first query result.?
I have table names in my list box to check if same tables has same columns. For Example
listBox3 has EMPLOYEE table name my query has to check if EMPLOYEE table has different columns.
This query ...
0
votes
0answers
9 views
Stored procedure / SYS_RefCursor - wrong number of arguments
Given that I have this Oracle stored procedure (it's a test example)
PROCEDURE dave IS
dave_data SYS_REFCURSOR;
v_col1 NUMBER;
v_col2 VARCHAr2(100);
BEGIN
DBMS_OUTPUT.ENABLE(2000000);
...
0
votes
1answer
10 views
oracle : query output not formated
SQL> SELECT TR_NAME,TR_VALUE FROM TBL;
TR_NAME
----------------------------------------------------------------------------------------------------
TR_VALUE
...
0
votes
0answers
5 views
can''t connect to oracle cloud in amazon AWS?
I am using this code for connect to oracle cloud in amazon:
public $driver_name = 'oci8';
public $hostname = 'xyz.xyz.us-west-2.rds.amazonaws.com:1521/xyz';
public $db_name = '';
public $db_user = ...
0
votes
0answers
3 views
Cannot Install ruby-oci8 on Ubuntu 12.04LTS
I execute
$ bundle install
For my rails application... (3.2.8)
Right when it gets to ruby-oci8 ...
Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.
...
0
votes
1answer
8 views
a spring embedded database with oracle syntax?
I have set my H2 datasource to be Oracle Mode both in the connector string and in my init script "SET MODE Oracle;"
but still , many functions can not be executed, such as the date "trunc" function, ...
0
votes
0answers
9 views
Method for accessing a remote Oracle Instant Client PHP database abstraction layer - is this even a thing?
I've got an interesting problem. I have a need to interface with an Oracle database for an existing application from an existing PHP application on a separate server. The Oracle DB is running on ...
0
votes
1answer
37 views
Range scan vs Unique Scan vs Skip Scan
When we talk about index scanning in SQL, the terms Range scan, skip scan and unique scan ARE USED. Most of the time there is a little confusion between which scan is better and where its use is more ...
0
votes
0answers
18 views
Getting SQL query execution statistic from Oracle database
I came from a background of MSSQL into the world of oracle (11g).
Back in MSSQL I used to be able to query the sys.dm_exec_query_stats and sys.dm_exec_text_query_plan table for the stats of the sql ...
0
votes
1answer
21 views
Using a Blob to get a file from database
I'm working on a database project using Oracle Express Edition and using JDBC. I have an excel spreadsheet within the database that I am working with (editing, updating, etc.) I recently started ...
0
votes
0answers
12 views
Return value from sql script to shell script
I have shell script that calls the following sql script:
INSERT INTO SEMANTIC.COUNT_STATISTICS (...);
UPDATE SEMANTIC.COUNT_STATISTICS
SET PRNCT_CHANGE = 1.1;
--want to store ...
0
votes
1answer
23 views
Select for update with subquery in GORM
How would I accomplish the following query with GORM?
select *
from T where id in
(
SELECT id
FROM (
SELECT *
FROM T
WHERE X is NULL
ORDER BY Y DESC
...
