Hi all, Im working on stored procedure where I need to retrieve a set of results and process each element individually and then return the entire result.(using 3 different tables) Im not too familiar with databases, but heres what I was able to come up with.. create or replace procedure GET_EMP_RSLT IS CURSOR ecursor IS select emp...
hi how to do this: select top 1 Fname from MyTbl in oracle 11g ? thank's in advance ...
I have a table in an Oracle database that contains actions performed by users in one of our systems. It's used for statistical analysis and I need to display the number of actions performed for a given date, grouped by hour of the day. I have a query that does that fine, however, it does not display the hours of the day that contain no ...
This Oracle documentation page mentions ... columns of type LONG are created last but doesn't say why. What can the reason be to store them at the end of a row? ...
I have build a stacked graph using oracle Reports 10g. I have 4 series in the graph, and i want to display marker text(data label in other words) for all except one series. i have tried with exceptional raiser but it is not worked out. any body have idea about it??? ...
From the oracle reports tutorial, http://download.oracle.com/docs/html/B10602_01/orbr_grpl_single.htm I have a requirement that is similar to the above report but would have the department id column to repeat each time instead of just once as above. So I tried following the steps and then moved the repeating frame of non-grouped fields...
I'm currently migrating a package of procedures from Oracle to DB2, with the assistance of the IBM Migration Toolkit. MTK unfortunately chokes on custom types, such as: TYPE G_reference_cursor IS REF_CURSOR ... FUNCTION do_some_stuff RETURN g_reference_cursor ... What would be the idiomatic way of migrating these statements to DB2?...
We are facing some annoying issues while trying to remotely connect to an Oracle database from a Windows Azure worker instance. The problem has been already discussed on the MSDN, but at this point, we are still stuck. Does anyone has succeeded in establishing a connection toward an Oracle database from a .NET app hosted in Windows Azur...
How to retrieve third row from any table using "rownum" key word ( i am using oracle-10g) ...
My project requires me to write a web application with JSP to communicate with Oracle 10g R2 The JSP/Javascript/HTML is held in OC4J 9i and the database is created with characterset as UTF-8. The interface between JSP and Oracle is based on JDBC Thin driver I tried to type in some Chinese characters on JSP page, then save to Oracle. In...
I run the below code in my C# .Net application, but I keep getting error ORA-01722: invalid number. When running the same SQL directly in PL/SQL Developer it does exactly what I ask it to without complaining. What could be causing this? OracleCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command....
Hi. I have a rails app under Oracle, Apache and Phusion Passenger. I use activerecord-oracle_enhanced-adapter-1.3.0 and ruby-oci 2.0.4. Every time I made a request, this error appear, even if the request is served correctly. Apparently nothing goes wrong, but my boss is very nervous about it and I didn't find any clue on Google about thi...
We are using oracle > 10.0 here and our software creates different types of reports for evaluation of the stored data. Because of the amount of data it is possible that such a report takes a couple of minutes to create and the customers would like to stop the queries. Is there a way to say the DMBS that it should stop a query? It would ...
Here is my query: select count(*) from email_prod_junc j inner join trckd_prod t5 on j.trckd_prod_sk = t5.trckd_prod_sk inner join prod_brnd b on t5.prod_brnd_sk = b.prod_brnd_sk inner join email e on j.email_sk = e.email_sk inner join dm_geography_sales_pos_uniq u on (u.emp_sk = e.emp_sk and u.prod_brnd_sk = b.prod_brnd_sk) The expla...
I tried to delete the data from tablespace using the command DROP USER xyz CASCADE; I found that user was dropped but size of my tablespace did not decreased. Is my data fom the tablespace have been deleted? If yes, how can I confirm that? And why was the space not deallocated? ...
Is it possible to have a look at what is there inside an index using SQL*Plus? If I have a table like this: Table A ------------------------ rowid | id name 123 | 1 A 124 | 4 G 125 | 2 R 126 | 3 P where id is the primary key, I expect the index to be something like this index on A.id ------------- id ...
I wish to extract a sub-BLOB (a few MBs) from a BLOB in Oracle. The question "read first 1kb of a blob from oracle" doesn't help me, since I need to get more bytes than DBMS_LOB.SUBSTR can give me (it returns RAW, which supports only a few thousand bytes). ...
Suppose I'm using the following Oracle code in a stored procedure: CREATE GLOBAL TEMPORARY TABLE temp_table ( field1 NUMBER, field2 NUMBER ) ON COMMIT DELETE ROWS This particular stored procedure may be called concurrently by different users at any single moment. As I understand it, the data visible to the user in the temporar...
Hello, Does anybody knows how could I make a trigger or anything else to prevent people to connect on my database with any kind of applications besides mine? Note that the super-old-and-unsecure trigger to block few .exe such TOAD or watever does NOT really works, since you can just rename the EXE to MyApplication.exe. Hints? ...
From here, Oracle ASM provides several advantages over conventional file systems and storage managers, including the following: Rebalances data automatically after storage configuration changes What kind of configuration changes are we talking about here? In a database, what kind of configuration changes happen? ...