Say I have a table which I query like so: select date, value from mytable order by date and this gives me results: date value 02/26/2009 14:03:39 1 02/26/2009 14:10:52 2 (a) 02/26/2009 14:27:49 2 (b) 02/26/2009 14:34:33 3 02/26/2009 14:48:29 2 (c) 02/26/2009 14:55:...
We're using a Oracle Text CTXSYS.CONTEXT index to index about half a million rows containing metainformation. The information is spread over two tables that are combined by a procedure that the indexer calls at runtime (functional index). When I run the CREATE INDEX on my local machine (simple dualcore notebook) the index is built in ab...
I tried to use xpath expression in task editor. Expression editor suggested me to use task schema and I could not use variables from process. I had selected systemMessageAttributes.textAttribute1 and created “Assign” activity to initiate the attribute. This does not work. When task is started assignee is empty and task is automatically c...
Hello, I am using Oracle SQL and I want to group some different rows that 'like' function results. To elaborate with an example: Let's assume I have a table MESA with one of the columns is a huge string. And I am counting the number of rows matching particular patterns: SELECT m.str, count(*) FROM MESA m WHERE m.str LIKE '%FRUIT%' A...
I was looking at oracle liecense, it looks cheap for named user plus. I mean if I develop a web application in which user has no interaction with database other than registering and logging in and if I make a virtual user inside server to do all these things that is get user name and password from users ect. keep them in queue and execut...
Hi, I have table with values as ColumnA ColumnB ASD A CSD B DSD C ESD D FSD D GSD D Column A is primary key, I need result as ColumnA ColumnB ASD A CSD B DSD C ESD D I want all unique values from column B & their a...
Hi Everyone: I'm trying to disable a button inside of a form region in Oracle Application Express (Apex v3) in an ajax-ified manner. I'm using jQuery to accomplish the ajax part. $('#P16_MYBUTTON').hide(); Doing a view source on the rendered page I noticed that the button doesn't have an ID even though in Apex I've given it a name...
That title is brutal, but I don't know how else to put it. I have a key value table tied to a user_id that stores user preferences throughout the site. If a user hasn't gone in and updated any of their settings, any time I ask for a key (say "FAVORITE_COLOR" it's going to be null, so I need to pull the default setting that I have tied ...
is it possible to send e-mail over ssl in plsql? thanks for helping. ...
Ok, so I got duped into doing some database design for an Oracle database where I work. The problem is, I'm not much of a DB guy :-). I'm currently using Rational Application Developer (RAD) to do the modeling of my database schema. What I'd ideally like to do is generate a series of Word documents, containing information from my DB sche...
i am facing this error when i start the oracle. I checked Oracle Home and SID. everything is set properly. ORA-27101: shared memory realm does not exist please help me to find out the solution. Thanks in advance ...
Is there a way in TOAD or some other tool to monitor queries being executed by your web app? I'd like to examine the explain/execution plans for the web app queries. I'm debugging why the webapp queries are slower than when run from sqlplus. ...
Hi, I am upgrading Oracle middleware suite from 11.1.2 to 11.1.3. When creating my weblogic domain, come to the step of testing database schema connections, it works fine (I have upgraded DEV_SOAINFRA to 11.1.3). However, when I start my weblogic admin server, I have this error : Received exception while creating connection for pool: ...
I'm trying to get a batch insert working with Hibernate into Oracle, according to what i've read here: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/batch.html , but with my benchmarking it doesn't seem any faster than before. Can anyone suggest a way to prove whether hibernate is using batch mode or not? I hear that there ...
I have installed Oracle 10g Express Edition. When try to test the connection I am getting the error "Error while trying to retrieve text for error ORA-01019". Below is my code. strConnection = "Driver={Microsoft ODBC for Oracle};Server=Servername;Uid=username;Pwd=password;" Set conn = CreateObject("ADODB.Connection") conn....
I Have problem in update one of my datablock textitem. the problem will raise up because I use where condition for my datablock,and after I load the data block, I try to get new value to my text item,but after I put value there is no change... I dont know how I can change a text item database value when my block has where condition.(th...
Hi. I have a very simple application on .Net that connect to Oracle using ODP (was compiled with Oracle.DataAccess dll 10.2). I want to check "connection prerequisite" (application will be able to connect to DB) before installing this aplication on other computers? How can I check that ODP.NET version 10.2 or higher is installed on tar...
hi all, which column i need to use to join V$session and V$sqlarea? My main aim is to find top 5 queries with most disk_reads and generate a report containing relevant information. Thanks ...
Hey there I’ve got a table like this: Create Table PersonAgent ( PersonID varchar2(10) not null, AgentID varchar2(10) not null, Address varchar2(50), City varchar2(50), Country varchar2(50) ) Well I need to generate this table new, coze some data are incorrect. If PersonID and AgentID are th...
How can I get all the information about a table, its columns and constraints etc in Oracle? I am using desc MY_TABLE but that's only giving me column name, nullness and type. ...