oracle9i Questions
2
Solved
How can I create a Sequence where my START WITH value comes from a query?
I'm trying this way:
CREATE SEQUENCE "Seq" INCREMENT BY 1 START WITH (SELECT MAX("ID") FROM "Table");
But, I get the OR...
2
Solved
Is there a way to find if a a particular Oracle index was ever used by Oracle when executing a query?
We have a function based index, which I suspect is not getting used by Oracle and hence some ...
Vociferate asked 24/10, 2012 at 0:45
1
Solved
I'm experiencing some interesting behaviour with using user-defined functions within a SELECT statement.
I have a couple stored procedures that read and purge data from a single table. These stor...
2
Solved
I am running following query in SQL*Plus
CREATE TABLE tbl_audit_trail (
id NUMBER(11) NOT NULL,
old_value varchar2(255) NOT NULL,
new_value varchar2(255) NOT NULL,
action varchar2(20) CHARACTE...
Hegarty asked 31/3, 2012 at 13:50
5
Solved
I am trying to understand what the +0 at the end of this Oracle 9i query means:
SELECT /*+ INDEX (a CODE_ZIP_CODE_IX) */
a.city,
a.state,
LPAD(a.code,5,0) ZipCode,
b.County_Name CoName,
...
1
I have a Field in ORACLE as CREATED (NUMBER). It stores the time in MILLISECONDS or you can say long format. Now the requirement is to find the data between two dates using the Field CREATED.
I h...
2
Solved
I am new to node.js and I already did my research with no success, so that is my question:
It is possible to use Node.js with an Oracle 9i Database? If so, where do I find some stuff about it?
Th...
Monadism asked 15/3, 2011 at 20:22
2
Solved
Is is possible to find out the datatype of a column of a cursor or variable within block without using system tables? While I understand that I can use the system tables to find out this informatio...
Persimmon asked 9/1, 2012 at 14:44
2
Solved
The below procedure (in Oracle 11g release 1) accepts a sql as a parameter & returns its return code.
Returns 0 if success
Returns 1 if no update or no delete performs
Returns actual error c...
Valentinavalentine asked 22/12, 2011 at 1:48
3
Solved
Assume you have the following update:
Update table set col1 = func(col2)
where col1<>func(col2)
The func function is evaluated two times for every row, or once for every row?
Thanks,
2
Solved
Why is there such a huge performance difference between these two queries?
-- (89 seconds)
SELECT max(mydate) FROM mytable WHERE eqpid = 'ABCDEFG'
AND mydate < sysdate - 5
vs.
-- (0.6 second...
Thundercloud asked 1/6, 2011 at 21:24
2
Solved
Hi all I have a 'widget' table that has the following columns: widget, action, timestamp_. What we want to do is pull all the widgets that were rejected more than once a day between certain dates. ...
3
as the title i am talking about, what's the best way to track data changes in oracle? i just want to know which row being updated/deleted/inserted?
at first i think about the trigger, but i need t...
Klaraklarika asked 20/4, 2011 at 6:43
1
Solved
There is a way to specify IBatis query timeout using oracle jdbc and Java?
Thanks
1
Solved
Is there anyone who can help me get the logical representation of a bitmap index and reverse key index?
Arthromere asked 31/8, 2010 at 8:54
4
5
Solved
Without getting into a discussion about whether the business logic should be in the database or at the application layer, since it has been covered elsewhere.
My team is translating 100K+ li...
2
Solved
I have made this job,that should be executed in an interval of 1 minute,but it's not working. When I use execute dbms_job.run(2); it gets executed. printe is a procedure
Please suggest!
BEGIN
DBM...
Electroencephalogram asked 2/5, 2010 at 8:39
1
I got the following error in Oracle:
SELECT * FROM abcd WHERE name LIKE 'a%' LIMIT 10
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
What is the problem with the command?
4
Solved
I am trying to write to an Oracle clob field a value over 4000 characters. This seams to be a common issue but non of the solutions seem to work. So I pray for help from here.
Down and dirty info:...
2
Solved
9
Solved
My SAMPLE table has the following five columns:
sample_id (PK) (NUMBER)
sampled_on (DATE)
received_on (DATE)
completed_on (DATE)
authorized_on (DATE)
I would like a query with one row per hour (...
3
Solved
I have a table with data such as below
Group Start Date End Date
A 01/01/01 01/03/01
A 01/01/01 01/02/01
A 01/03/01 01/04/01
B 01/01/01 01/01/01
ETC
I am looking to produce a view that gives a c...
Thule asked 8/9, 2009 at 13:51
4
Solved
I'm Working with a new Oracle DB, with one table having the following indexes:
Index 1: ColA, ColB
Index 2: ColA
Is the second index redundant, and Will this have a negative impact on performa...
Apopemptic asked 19/6, 2009 at 20:37
3
Solved
I'm trying to SELECT from the dba_tab_cols view from within a stored procedure. It's not working and I don't know why.
If I execute the following SQL as a query:
SELECT t.data_type FROM dba_tab_c...
Dhiman asked 29/4, 2009 at 18:25
© 2022 - 2024 — McMap. All rights reserved.