Top "Oracle" questions

SELECTing top N rows without ROWNUM?

I hope you can help me with my homework :) We need to build a query that outputs the top N …

oracle rownum

ORA-27101: shared memory realm does not exist

i am facing this error when i start the oracle. I checked Oracle Home and SID. everything is set properly. …

sql oracle ubuntu oracle-xe

How to call an Oracle function with a Ref Cursor as Out-parameter from C#?

I'm using a product that provides a database API based on Oracle functions and I'm able to call functions via …

oracle function odp.net sys-refcursor ref-cursor

MD5 in Oracle (DBMS_OBFUSCATION_TOOLKIT.MD5)

I'm trying to compose a function to obtain MD5 hashes from bits I've gathered here and there. I want to …

oracle plsql md5 oracle-xe subtype

Pass and return custom array object in ibatis and oracle in java

I've looked around for a good example of this, but I haven't run into one yet. I want to pass …

java oracle ibatis

toad for oracle autocomplete dropdown

Toad for Oracle has an autocomplete feature.. you type SELECT * FROM USER. and then press Ctrl+. and a drop down …

oracle plsql toad

Using distinct on a column and doing order by on another column gives an error

I have a table: abc_test with columns n_num, k_str. This query doesnt work: select distinct(n_num) …

sql oracle sql-order-by distinct oracle9i

java.sql.SQLException: Connection is closed

I am making a quartz thread application that is collect data from a table and insert it in another table …

java oracle ojdbc

Using NVL for multiple columns - Oracle SQL

Good morning my beloved sql wizards and sorcerers, I am wanting to substitute on 3 columns of data across 3 tables. Currently …

sql oracle coalesce nvl

Oracle: Pattern for to_char(number) to add additional ascii characters?

Using the Oracle to_char(number) function, is it possible to append ascii characters to the returned string? Specifically, I …

oracle formatting numbers ascii oracle-apex