Oracle Help
in [SQL]
|
Q: something like rownum Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 This sounds like it should be super simple, but I can't think how to do it using plain SQL. I am going to display some rows, and I want to number them in the display, like using rownum, except that the number only goes up when the row has some propert... 17 Apr 2008 15:45
Oracle Trigger Late binding i want to use if(:new.column_name is not null) which works perfect... however my problem is that i want to set this column_name as a run time variable (as the table columns are not known to me) I tried using a variable but oracle throws a PLS-00049 bad bind variable error. Please help... ... 17 Apr 2008 14:57
HowTo find out used (useful) and unused (usesless) indexes? Hi, Is there a way to find out what indexes are used(useful)/unused(useless) while the last few days/weeks? If possible so tell me a way via data dictionary without using any external tools. Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de ... 21 Apr 2008 14:56
Hierarchical Subquery must omit nodes Hi all, I thought this would be easy but it's turning out to be pretty difficult. I need a hierarchical query to omit nodes present in a EXCLUDED_NODES table. Omitted nodes' children should be omitted too. See this example taken from http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/functions12... 17 Apr 2008 11:44
Query Improvement Hi, I posted this about a week ago and am still having issues trying to improve this query. This is a nasty query here which I'm hoping to make smaller by using some joins. I got help from here before, so while I'm trying to do it, I was hoping some others can look at it also. Thank you, SELECT ... 16 Apr 2008 12:25
Excel to Oracle Hi, This page describes a tool to move data from Excel to Oracle. http://thinktibits.blogspot.com/2008/04/excel-to-oracle-oraexcel.html Can somebody send me the download link for this tool? I cannot find it in google. Cheers! ... 16 Apr 2008 12:25
Problem with Unicode Strings Hi, I am having trouble with stuffing in an getting out unicode strings into/from my database. I will briefly describe what I am doing, hoping that someone can point me to a mistake and end my weeks of trying... * Oracle 9i client and server, connecting via OCI from a C++ (MS Dev Studio 2005) application * Cl... 15 Apr 2008 09:07
Problem with Unicode Strings Hi, I am having trouble with stuffing in an getting out unicode strings into/from my database. I will briefly describe what I am doing, hoping that someone can point me to a mistake and end my weeks of trying... * Oracle 9i client and server, connecting via OCI from a C++ (MS Dev Studio 2005) application *... 16 Apr 2008 14:50
Filling up the results of a query Hello, I could not find an answer for my following problem through Google, maybe because I did not find the best keywords. So I hope that one of you can help me. I need to create a view that "fills up" the entries of a table. Example: Let's consider a table t_rates with bank rates for borrowing money for a ce... 21 Apr 2008 23:44
Increase your Oracle security knowledge Just increase your job prospects by increasing your knowledge regarding Oracle databases with the help of Secure Auditor. It audit Oracle databases and provide complete Vulnerability description, overview and reference along with methods to mitigate vulnerabilities from Oracle databases. It will definitely increase... 14 Apr 2008 03:54 |