We have a website that makes use of OAM for single sign on (form-based authentication). When we submit credentials to WebGate / Access Server the authorization succeeds, however after the authentication is performed, the form action (as configured in the Authentication Scheme - with passthrough:no) returns a server error instead of redir...
Hi Oracle experts. I'm having a little issue with a piece of bulk collect sql that I was hoping you could help out with. With the following code: declare cursor c1 is select customer,product from products; type type_cust is table of products.customer%type; type type_prod is table of products.product%type; ...
I have a table with a field named COMMENT, which appears to be a reserved word. Using SQLDeveloper, if I try: select [COMMENT], another_field FROM table_created_by_idiot_developer I get SQL Error: ORA-00936: missing expression How can I access this field in my select in SQL Developer? (Is this a problem with SQL Developer, or...
I want to delete all data from a table that has a date prior to 01/01/2006 I am trying this: delete from table_a where to_char(last_update_date,'MM/DD/YYYY') < to_char('01/01/2006', 'MM/DD/YYYY') But this is not working. What is the best way to compare date's in sql? ...
We have an Oracle Enterprise database in production and another instance that we use as both a QA and Development database. QA has requested that they be given separate schemas within the database so they can test applications isolated from changes made by developers. For an example, say the schema used in development and the one that ...
I've been using a parameterized query to insert values into an Oracle table, like so: var q = "insert into MyTable(Field1, Field2...) values(:Field1, :Field2...)"; var cmd = new OracleCommand(q, conn); // conn is a pre-existing connection cmd.Parameters.Add("Field1", field1Val); cmd.Parameters.Add("Field2", field2Val); // etc... cmd.Ex...
As example : I have this scenario where we receive payments, a singular payment per family, and register those payments with it's amount in the DB. The thing is that a family can move their loan from bank1 to bank2, only if they have 12 or more sequential payments. As example if they have registered a payment for oct, nov, dec, jan, ...
I'm trying to see if a particular column in a table in my Oracle database has any strings which contain a newline character, so a wildcard, a newline, and another wildcard. I've tried the like command and a combination with CHR(10) and tried escaping the newline itself, but to no avail. What would be the proper way to detect a newline ...
I figure I might just be missing some obvious syntax but what is the sql (oracle) to select the first 10 records, then the next 10, and so on? I tried using rownum but can seem to get rownum > X and rownum < Y to work. llcf ...
Hi all, I have a table with several columns and a unique RAW column. I created an unique index on the RAW column. My query selects all columns from the table (6 million rows). when i see the cost of the query its too high (51K). and its still using INDEX FULL scan. The query do not have any filter conditions, its a plain select * from...
I have a oracle(10.2) PLSQL procedure which fetches 15 records from a table in a sysrefcursor. I then pass this cursor to a java class as a resultset. This java class is loaded to oracle. Driver name : Oracle JDBC driver Driver Version : 10.2.0.1.0 Driver Major Version : 10 Driver Minor Version : 2 Observations: 1 Inside the java clas...
Hi all, I need to sync an oracle text index. But job fails to create: declare v_job_id number(19,0); begin dbms_job.submit( JOB => v_job_id, WHAT => 'alter index NAME_IDX rebuild parameters (''sync'');', NEXT_DATE => SYSDATE + (1/24), INTERVAL => 'SYSDATE + (1/24) + 7' ); end; / Or to run: de...
I would like to use a materialized view that refreshes ON COMMIT. My backing view joins two tables in the local database and one table in a remote database via DB Link. How can I have the view refresh only when changes are made to one of the two local tables? Are there any other ways to solve this problem? Can I have the materialized...
Hello guys, I have a database (which I can not modify) with 6 tables in Oracle 11g. All tables have a OID artificial column for ID, and its type is RAW(16). The DBA answered me that they are in raw and not in integer because this way the IDs will be unique in all six tables - and we must guarantee that. I'm developing the UI in C# and ...
I have a table with two number columns, and a unique constraint over them both. I would like to insert a new pair of values UNLESS the pair already exists. What is the simplest way to do this? If I do insert into TABLE values (100,200) and the pair already exists I get a ORA-00001 error, so I would like to do something like inser...
I'd like to test whether given SQL statement is syntactically and semantically valid (ie. no syntax errors and no field misspellings). For most databases Connection.prepareStatement and PreparedStatement.getMetaData would do the trick (no exception == good query). Unfortunately Oracle's newest driver only parses like this only SELECT qu...
I am a bit in a pitch here. We have got a development environment and a sat environment for our oracle databases. Here is what I want to achieve. I want to copy data from an x number of columns of my dev. environment to the same x number of columns of my sat enviroment. I've already tried some stuff and have created a couple of function...
Everything's in the title. I am Looping on a cursor and would like to have the EXIT WHEN curs%NOTFOUND when there is no more row, what is the equivalent of %NOTFOUND under PostgreSQL ? Edit Or the other cursors attributes %ISOPEN, %EMPTY, etc... ...
I have the following HQL(The Hibernate Query Language) query (which is executed on oracle db connection) to retrieve an aggregated sum, based on month select sum(doc._masskg), case when (month(doc._date) = month(:m)) then 'NOW' else 'BEFORE' from Document doc where month(doc._date) <= month(:m) group by case when (mont...
I'm looking for tips in debugging some of my row-level security predicates in an Oracle database. These predicates use a few concepts to determine whether the current user can see a record: current user's Oracle username current user's assigned Oracle roles current user's affiliation with a record in one or more tables I'm having tr...