Oracle Help
in [SQL]
|
Retrieve case sensitive tables Hello, I'm trying to retrieve a list of tables from all_tables in a given Oracle db. I'm using the .NET provider (by Microsoft) and I always obtain the results in uppercase. The problem is that some tables where defined in "Mixed/Case" so when I retrieve the list I need to obtain the exact case used when they we... 8 Jan 2008 01:45
any way to get MAX? Hi all , i want to get out of the data, the most popular good/month i have in my data, i figured out that it would be the one having the maximum sales, so i m using the following formula to see for every month, and every product, and how much were the sales this month, now the solution would be if i can get t... 6 Jan 2008 16:10
PL/SQL Collections Could someone please help me to better understand the application of collections in PL/SQL? Specifically, I wish to better understand when to use a record, table of records, and various arrays. Plus what are the trade-offs for applying one over another in various situations. Thanks! ... 6 Jan 2008 12:50
how can i put multiple statmwnts in sum(case... hi all, how ca put multiple statmwnts in sum(case statment? like if i have 4 regions, and 1 product, if for each region the transport fee is different, in a sum case how can that be done, is there any " nested if statment". i tried this and of course this is not the correct result: SUM(CASE WHEN prod_1.category ... 6 Jan 2008 16:10
formula help please hi all , i want to take out of the data (more than one table) the total purchases and the total sales, put each in a column near to each others and group the rows by months and years, so i thought in pseudo code something like this would work: if to_char of date (MM-YY).sales = to_char of date (MM-YY).purchase a... 6 Jan 2008 12:50
buzz spamming "lawryy" <lawry_jim(a)yahoo.com> schreef in bericht news:5d263cf0-99be-4d9b-98c3-c4bcd4983743(a)s12g2000prg.googlegroups.com... http://coderbuzz-programming.blogspot.com You've been reported to Google again. All: please check the 'mark this blog' on the site. ... 5 Jan 2008 12:16
Oracle Jobs JustOracle.com is a great source for Oracle jobs across all sectors like Apps Functional, Apps Technical, DBA, Developer, Web server, Designer, Trainee, Analyst, and Programmer etc for Oracle Professionals. ... 5 Jan 2008 10:34
invalid relational error, please help hi all i am having the following error : ORA-00920 invalid relational operator i read the quotes of other people who had the same problem but i didnt understand how this ties to my situation, since it is about memory and relative things, since the formula when working with other tables in my DB shows no proble... 5 Jan 2008 09:26
Consultation required Hi All, I am SQl DBA professional working since 2 years and I also want to work on Oracle. So, Please suggest me that should i start with Oracle 9i or Orcale 10g. Thanks in advance! Gourav ... 4 Jan 2008 16:24 |