Oracle Questions
ORA-20001: This record has been entered already
Comments: 3
Problem: Attempting to migrate data to an Special Information Type (SIT) structure using a callable API. 1. I have a API that successfully migrates data to an SIT structure for one employee...
How do I select a date range in Microsoft SQL server
Comments: 5
I a using this SQL statement. However I am getting dates from before 1st January 2009. SELECT VisitNo, CustomerID, SiteID, CallOutNo, visit_id, call_date, despatch_date, CAS...
How to write query for this one?
Comments: 7
I have two tables domain n details: domain has domainID and detailID (both are foreign keys), domainID is referenceing to primary key of another XYZ table. And detailID referencing to deta...
Difference between .sql file and .bat file
Comments: 5
As for my knowledge, I think .bat files are used to run multiple .sql files in the particular order. But we can do this by writing a simple .sql file also, like my xvz.sql contains: set echo o...
ora-01427 single-row subquery returns more than o…
Comments: 5
Experts, I get ora-01427 single-row subquery returns more than one row error when trying to update my table. Any help is appreciated. THanks in advance. UPDATE OUT...
Making a local copy of oracle server db
Comments: 5
Actually I have oracle 10g client in my machine and using oracle sql developer for queries. I got 3 server databases: Developing server, testing server n production server. For development ...
UPDATE statement syntax help
Comments: 7
Experts, This query is taking way to long....I mean way to long...what is wrong with it? UPDATE MyTable tabA SET PROV_REPGRPID = (SELECT DISTINCT REPGRPID_P...
i need to get the tables which is having partioned (dba wo…
Comments: 6
hi all, i am having lot of tables in my database and i would like to know the tables which is partioned and which is not(i need partion names,schema names only for tables which is having size greate...
convert values in a column to multiple columns
Comments: 6
Hello experts, I have a table like: CustomerID DateOrdered DateShipped ProductID 12A 12/12/09 12/21/09 AU89 12A ...
external table problem
Comments: 7
I have a .csv file with the following data in it: "30094","NON-US ACCOUNTS","300","NATIONAL MANAGEMENT","30","NATIONAL",1/1/2007 0:00:00...
error PLS-00103: encountered the symbol "CURSOR"
Comments: 5
Using PL/SQL in Oracle 10g express, I've created a procedure that does a lot of conditional processing, inserting intermediate results in work tables that are subsequently read from for the next pro...
extract text from a data field
Comments: 3
I have varchar field that I need to pull text out of, the amount of characters is unknown, but I do know that what I need is always between a ‘:’ and ‘:’. Actually the left is always the same and ...
Update multiple columns in one table joining to another table …
Comments: 2
Hello experts, I need to update multiple columns in one table with values from another table joining on 2 fields. In SQL Server this is a very simple query. I'm having no success with Or...
How to dump DBMS_OUTPUT.put_line int to a file?
Comments: 3
I want to write DBMS_OUTPUT.put_line('********Missing Owner ID into CSV File********************'||orderList.user_id); into a file rather than to a console, HO...
Need tofix ORA-01436: CONNECT BY loop in user da…
Comments: 10
I have a table structured below which is ordered by mem_id, adm_date. I needed it compressed to the second example. MEM_ID ADM_DATE DIS_DATE ALL_AMT --------...
Can I use a cursor inside the inside the LOOP
Comments: 22
HI II am writing a plsql, I am going through some tables to get some values, and base on those values I will have to update a table. The values which needs to be updated are stored into a temp table. H...
How do I replace variable in where clause.
Comments: 14
Hi, I'm havig an issue here now, if I hard code value for contract_id works fine but if I replace it with the variable v_contract_ID it says no data found. how to use variable in where clause ? ...
Cant run this using SQLPLUS
Comments: 7
I cant run this PL/SQL I keep getting line number, forexample 30 and when i type ; it aks for next line number ans son on, Thanks in advance DECLARE v_contract_ID contracts...
Need SQL procedure for below Logic.
Comments: 19
I have to do an update on address table based on some data , in order to get he right user - order mapping I have to go through different table see the details below. Step1) I need to create a t...
SQL, how can I show a row if the manager id is blank.
Comments: 2
SELECT worker.employee_id, worker.full_name emp, manager.full_name FROM emps worker JOIN emps manager ON (worker.manager_id = manager.employee_id); ...
Simple query
Comments: 4
Hi I have 2 tables, to make it simple i am not mentioning all the columns, so both these tables have addtional columns aswell. Table1 has 2 colimns UserID and Addr_ID Table2 has agai...
retrieve DATA_PARAMETER type parameter in GRAPHICS …
Comments: 3
I am adding a DATA_PARAMETER type in a list and using that list to call graphics(chart) from FORMS which is embedded on the forms. How can I retrieve the DATA_PARAMETER in graphics t...
SQL ORDER BY last_name without field being part of SELE…
Comments: 13
How do order by last name when writing/executing an SQL statement that lists only the following four columns: employee_id, FULL_NAME salary and department_id. This is what I came up ...
PLSQL/LOGIC IMpLEMENTATION
Comments: 7
select distinct SDSECM01.FT_W_WPTY.PRTY_NME from sdsecm01.ft_w_wpty,sdsecm01.ft_w_acct,sdsecm01.ft_w_wpar where sdsecm01.ft_w_wpar.acct_s...
Aggregate based on two date columns
Comments: 4
Experts, I have a table ordered by MEM_ID, ADM_DATE and structed like... MEM_ID ADM_DATE DIS_DATE ALL_AMT ------------------------...
Stay Connected
Featured Oracle Articles
- Free Oracle tips from Experts Exchange
- How Oracle Stores Passwords
- How to FTP with Oracle PL/SQL
- How to Send Email Attachments with Oracle
Free Oracle tips from Experts Exchange
How Oracle Stores Passwords
Many times a DBA may want to replicate a user from one system to another and migrate that same password,such as refreshing a production system ...
How to FTP with Oracle PL/SQL
Sometimes you need to get data from a server into your database or from your database into a remote server. Learn how to use FTP to ...
How to Send Email Attachments with Oracle
Oracle introduced the UTL_SMTP package with the release of 8i back in 1999, but up through the current version (11.2.0.1) available on OTN...
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
Know a thing or two about Oracle? Join our team of experts today.