Oracle Questions

Sort by:

VC++ ADO and stored procedure

Comments: 2

Hi, I am migrating a VC++/SQL server app to using Oracle. The database access is implemented using ADO classes, and I have a problem very much like http://www.oraclesolved.co...

Author: ericgenTags: Stored proced..., cursor, VC++ asked 37 days ago

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...

Author: michaelhardenTags: Database, SQL Developer asked 2 years 86 days ago

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...

Author: CMChalcraft asked 2 years 190 days ago

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...

Author: sridhar_ravva asked 2 years 191 days ago

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...

Author: sridhar_ravvaTags: Difference bet... asked 2 years 192 days ago

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...

Author: jvoconnellTags: ora-01427 asked 2 years 195 days ago

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 ...

Author: sridhar_ravva asked 2 years 196 days ago

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...

Author: jvoconnellTags: Oracle UPDATE asked 2 years 198 days ago

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...

Author: nagavenuiluri asked 2 years 204 days ago

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 ...

Author: jvoconnellTags: Oracle multiple... asked 2 years 205 days ago

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...

Author: sridhar_ravva asked 2 years 205 days ago

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...

Author: roberwilkTags: cursor, pls-00103, encountered t... asked 2 years 205 days ago

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 ...

Author: van-coug asked 2 years 209 days ago

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...

Author: jvoconnellTags: Oracle Join M... asked 2 years 210 days ago

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...

Author: AjooAliTags: SQL asked 2 years 212 days ago

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 --------...

Author: jvoconnellTags: ORA-014... asked 2 years 216 days ago

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...

Author: AjooAliTags: PL SQL asked 2 years 216 days ago

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 ? ...

Author: AjooAli asked 2 years 216 days ago

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...

Author: AjooAliTags: PL SQL asked 2 years 216 days ago

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...

Author: AjooAliTags: PL SQL asked 2 years 216 days ago

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); ...

Author: 28JoplinTags: sql, oracle 11 asked 2 years 216 days ago

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...

Author: AjooAliTags: PLSQL asked 2 years 216 days ago

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...

Author: mkarthik415Tags: ORACLE FOR..., PL/SQL asked 2 years 217 days ago

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 ...

Author: 28JoplinTags: sql, oracle 11 asked 2 years 217 days ago

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...

Author: Kanigi asked 2 years 217 days ago

Stay Connected

Oracle Around the Web

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 ...

read more

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 ...

read more

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 ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

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.

    BrowseBecome an Expert