Oracle Questions
Create a DB Link to access 1 table only
Comments: 1
I want to create a db link that will have access to only 1 remote table.
Oracle restore and recover database
Comments: 1
I have oracle 11g database online hotbackup from windows vista and I want to restore the same online hotbackup on another server that is also windows vista. what are the steps to follow
oracle forms 10g and database service name
Comments: 7
hello i have oracle database 10g and oracle developer suite 10 installed in my pc. whenever i try to connect from the forms 10g I get the 12154 error "Could not resolve service name"....
Trigger will not trigger
Comments: 6
Hi I have a trigger that executes when there is a update to table et812.f986110 the trigger updates table ctm999.ctrlm_e1_jobs. For some reason the trigger will not update t...
Joining two tables in Oracle
Comments: 3
I have two tables T1 and T2 I need to return all rows from T1 that do not show up in T1. This is what i have done... Select T1.Tag, From T1, T2 Where T1.Tag...
fiscal date range from old db
Comments: 11
looking for concept on fiscal year date range old database there is not a date field I need to work with 2 columns i'll call them fyear & tdate - both char columns fyear is the fiscal year ...
String Date Conversion Problem
Comments: 9
Hi, I need to convert the following VARCHAR2 US dates in a customer DB .. 4/4/2010 11:59PM 2/4/2010 12:02AM ..to 04/04/201...
How do I get the highest product price for a type of price an…
Comments: 4
I have two tables in Oracle 11G: PRODUCT Product_id Product Name Product_Type PRICE Product_id Price_type Price_date Price I would like to g...
handling hierarchy in oracle sql query
Comments: 6
I have two tables: The first contains COMPANY_ID and CATEGORY_ID The second contains CATEGORY_ID and PARENT_CATEGORY_ID I need to return a list containing COMPAN...
how to optimize the query to pull the difference between 2 …
Comments: 20
Hi I have a situation that I need to develop a sql for user to compare the data in a field in table A that needed to be verified with another same identical field in table B and pull out the differences in table 1 c...
Oracle 8i under Windows 7 64-bit
Comments: 8
I have managed to install the Oracle 8i client under Windows 7 64-bit but when I try to add new Oracle data sources via the ODBC Administrator utility, only SQL Native Client and SQL Server drivers ...
Create Linked Servers to Oracle Database
Comments: 14
I am trying to create a linked server to connect to oracle database and when I run the select statement I got this error message "OLE DB provider "MSDAORA" for linked server "ORACLE" returned me...
ORA-00900: invalid SQL statement
Comments: 16
I want to call the procedure below from my .net page but when I try to execute it in toad, I get the following error "ORA-00900: invalid SQL statement" What am I doing wrong? Tha...
PL/SQL - common table expression in proc
Comments: 2
Hello all, I have a "WITH" common table expression for example: WITH mytable AS (select * from links) That I need to JOIN to in my stored proc. The stored proc h...
Oracle errors in shell scripts
Comments: 13
Hello, If I have the following in a shell script: #!/bin/bash ... sqlplus user/password@database @script1.sql sqlplus user/password@database @script2.sql ...
PL/SQL - in stored proc have month and year, need to g…
Comments: 8
Hello all, I have two variables year and month and I need to get the end day of the month into another variable which I dont have. Is there a way to do that within the proc?
PL/SQL - Global Temp Table or Alternative - Stored Proc…
Comments: 9
Hello all, When creating a global temp table does that actually create a physical table? I have to place in my stored procedure a temp table that can only be used until the end of the proc and then ...
What is the MS Access database SQL syntax for this query?
Comments: 4
I have this: select distinct (trunc(DWS.ITEM_RTL_UPC_VW.RTL_UPC_NUM / 10)), PRODCURRP.ITEM_DESC, PRODCURRP.BSE_ITEM_SZ_PK_QTY, PRODCURRP.BSE_IT...
Table function in oracle
Comments: 4
Dear Experts, Why i have to use table function in oracle pl/sql ?. How effectively i can use table function ?. Where i have to use it ?.
Use Variable in TO_DATE Function
Comments: 10
Hi Experts, I need some help. Trying to write a query in TOAD and not real sure how to use prompts and then use the input as a variable. I'm wanting to prompt for a date and then use the respon...
load a pipe delimited file into oracle table
Comments: 8
I have a pipe delimited text file of addresses. For example: 1|G123456|123 Some street| Somwhere|MN|22222 2|G123456|123Another street| Somwhere|MN...
Getting Multiple Counts from within one column in Oracle
Comments: 5
I have a table with 2 columns (USERID,INVOICE_AMOUNT). I need to pull multiple counts from this table based upon INVOICE_AMOUNT so I can see how many invoices a particular user approved ...
oracle session problem
Comments: 5
When I execute a procedure in an Oracle session, first time it is executing well but 2nd time it is not executing in the same session. I am forced to open a new session and execute. Can you please let ...
how to change date format when loading data from flat files…
Comments: 11
Hi all, I am migrating form red brick database to oracle. The flat files are available on sql server. so i have to basically load data from flat files on sql server into external tables and merge it th...
PL/SQL Easy Question - Null or Blank
Comments: 5
Is there a length I should use where I need to say if not null and not blank so I was thinking there is a length in PL/SQL on a field that may be best unless another way is better. Also I am doing some ...
Stay Connected
Oracle Around the Web
- The latest Oracle news, tips, and tricks
- Oracle Unveils Netra SPARC T3 Servers
- Oracle fixes 21 flaws in Java SE, Java for Business
- Obama’s Silicon Valley “Tech Supper”
The latest Oracle news, tips, and tricks
Oracle Unveils Netra SPARC T3 Servers
New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...
Oracle fixes 21 flaws in Java SE, Java for Business
Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...
Obama’s Silicon Valley “Tech Supper”
Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...
Featured Oracle Experts
Testimonials
What users are saying about our experts
"The Oracle gurus provide answers, solutions and valuable workarounds"
User: schwertner
"Wow! Excellent, valuable explanation. Hats off to you"
User: aseshu70
"Solution worked fantastic and performs excellent! Thanks heaps"
User: klausbrandlhuber
Top Experts
-
slightwv
2,000
0 points yesterday
Profile