Oracle Help
in [SQL]
|
Job post spam appology Hi Everyone, A post I sent earlier seemed to be construed as spam, I apologize and will repost in the marketplace. -Corey ... 24 Apr 2008 19:50
EXECUTE IMMEDIATE statement FAILS Hi all, My procedure below is failing to provide the desired result and I've failed to track down what is the cause. The procedure is supposed to dynamically grant roll on objects to users. I've tested the cursor SQL and it's working fine. However, sql_stmt is failing. When I run the procedure I get the followin... 24 Apr 2008 18:15
Pro C & OCCI mix I have an huge application written using C and Pro/C. I want to write C ++ function which will access oracle using OCCI. Can I reuse Pro/C connection? ... 24 Apr 2008 09:26
For 10g OCP: request info about upgrade exam 11g Did someone take the exam 1Z0-050 11g New Features for administrators ? I would like to know: How much difficoult it is. Where did you study ? Did you attend the relative course ? Is it bettere to wait database release 2 and relative course and documentation ? Thank you Golan Trevize ... 24 Apr 2008 19:50
PL/SQL Programmer Needed in Houston PeopleQuest Staffing is currently looking for highly organized multi- talented Software Programmers with extensive IT experience for our client in West Houston, TX. This is a Contract position with one of the Nations leading Energy Solutions providers. Please read the following job description and if you feel... 24 Apr 2008 19:50
Installing the Oracle Database Made Easy http://www.youtube.com/watch?v=CHzV4LZnvHc http://www.youtube.com/watch?v=SNW-7jCBWsw -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan(a)x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org ... 24 Apr 2008 14:15
find word greater than 17 i am looking to find the first word of a field greater than 17 select businessname from tablename where CHAR(' ', businessname + ' ') > 17 ... 23 Apr 2008 22:55
Query using group i have a table with 4 columns, they look like currency1 currency2 amt1 amt2 ======================= USD GBP 10 9 GBP USD 5 8 JPY INR 20 7 INR JPY 14 100 i want to cross add the amounts for each group of currency1 and currency2. now, the currency groups are bit unusal. Fo... 23 Apr 2008 09:19
Help with Query Hi, Please take a look at this query: SELECT max(action_date), customer_id FROM email_product_hist WHERE action = 'A' AND action_date BETWEEN TO_DATE('01012007','MMDDYYYY') AND TO_DATE('03312007','MMDDYYYY') AND email_product_id = 'PPM' AND customer_id NOT IN (SELECT customer_id FROM new_customer.c... 23 Apr 2008 09:19
Scanning/mining Oracle 7 (v7.2.3) redo log Hi, Has anybody come across any tools/products that can scan the Oracle 7 redo log to identify the data changes and do something with it? Have you worked in this area? Thanks. ... 22 Apr 2008 10:40 |