My understanding of database cluster is less because I have not worked on them. I have the below question. Database cluster has two instance db server 1 & server 2. Each instance will have a copy of databases, considering the database has say Table A. Normally a query request will be done by only one of the servers which is randomly de...
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 ORA-01722 error ...
I need a query (ORACLE) to pull all the table names and column names in a database for a given value? Example: If I give a value as "TEST", I need a query which pulls all the TABLE_NAMES and COLUMN_NAMES which has the value "TEST". ...
EDIT: changed the title to fit the code below. I'm trying to retrieve a list of acceptable values from an Oracle table, then performing a SELECT against another while comparing some fields against said list. I was trying to do this with cursors (like below), but this fails. DECLARE TYPE gcur IS REF CURSOR; TYPE list_record IS ...
I'm working with an Oracle 10g database, and I want to extract a group of records from one table, and then use that for pulling records out of a bunch of related tables. If this were T-SQL, I'd do it something like this: CREATE TABLE #PatientIDs ( pId int ) INSERT INTO #PatientIDs select distinct pId from appointments SELECT * fr...
Now, I'm pretty sure that it's not possible, but I want to 1) Confirm this, and 2) Hear alternatives. My solution today was to run the MySQL query, then use its result to construct a "NOT IN ('value1', 'value2', 'value3')" string, which I tacked onto the Oracle query before running it. Rather cumbersome, but it worked, and it's fast eno...
I have a table in Oracle that is currently storing close a Million Records. This table is having 2 CLOB columns that store XML data. I also have a search screen built for this particular table where users can search on pretty much all the columns except for the CLOB columns. Now here is my questions - Assuming that I have right indexe...
I want to add char in Select statement. Ex: SELECT '.' + OUTTRUNK as NUMBER Expected Result: .348977834 .456935534 .090922834 .234999734 How can I do this? Thanks. ...
According to the JDK 7 feature list Java's Unicode support will be updated (from Unicode 4.0 in Java 6) to Unicode 5.1 although Unicode 5.2 is available since October 2009. What's the reason for that considering that Unicode 5.2 was mostly an update of the Unicode book? EDIT: Java 7's Unicode support will be updated to Unicode 6.0. ...
I've been asked to document an Oracle database. I don't need EER diagrams or anything fancy: a simple printable document with a description of tables and columns will do. However, I'd prefer not to type the column names for all the 79 tables. Is there any tool to extract this information from the database server, possibly with some basic...
In our Oracle datbase we have a table called RULES, with a field called SQLQUERY. This field is a varchar with an SQL statement stored. The PK is DM_PROJECT. A typical statement that is stored could be select ACCOUNTNUMBER from CUSTOMERS where ACCUMULATED_SALES > 500000 I want to do something like this: select * from customer...
I have what seems to be a standard java problem: multiple database transactions, in Oracle, that need to all be committed or none. This is complicated by the fact that each process is in a seperate JVM. The modules are connected by JMS queues in a pipeline configuration. The idea is that a series of messages can be passed through the p...
hi all, I'm trying to schedule a job in oracle 10g but it says: ORA-01846: not a valid day of the week. Heres my code: declare v_job_id1 number(19,0); v_job_id2 number(19,0); begin dbms_job.submit(v_job_id1, 'CTX_DDL.OPTIMIZE_INDEX(''PSO_KEYWORD_SEARCH_IDX'', ''FULL'', 45);', NEXT_DAY(TRUNC(SYSDATE), 4) + 13/24, NEXT_DAY...
Hi all, I have a table, let's call it attachments. I have an attachment id and the attachment filedata. However, unfortunately, when the files are uploaded, the size of the file is never put into a filesize field.....so I have a bit of a predicament. Is there a way I could do a query to calculate the size of a. a files size in megabyt...
Heyho, I want to know what is the maximum value the number-format? For example int32 can handle 4.294.967.296 values. Greetz to the world! =) ...
We are seeing a lot of "ORA-00936: missing expression" errors in our application log. Is there a way in Oracle to determine what statement(s) are failing? I tried querying v$sql, but these statements are not inserted into that view, since they don't pass the syntax checks. Our C# application is using Linq to generate a query to an Orac...
I have a Varchar day column and I would like to select all rows where the day from day column matches current day in the system. I came up with this query but it didn't find any match, although today is Thursday and there is Thursday stored in the day column. I'm not sure if this is the right way to compare date data type with varchar. ...
Hello, I need to translate a script from tsql to plsql, something like: DECLARE @temp_id int INSERT INTO Table (col1, col2) VALUES (1, 2) SET @temp_id = @@identity but, I am having trouble to find something similar to global variable @@identity Oracle expert anyone? ...
My guess is that it shouln't have because they use centuries also in dates From here, The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds (after midnight). Did it face the problem? ...
So for a weird reaon my table was dropped but the constraints remained so I cannot recreate the table with the same constraints.. Is there a way I can drop those constraints? When I do a select in the all_constraints table: select * from all_constraints where CONSTRAINT_NAME like 'C710%'; I get this: ("x" being the table_name which me...