Oracle Questions
Oracle Query to split column and wrap text if string exceed…
Comments: 2
Please consider the following: I have a table with a column defined as Varchar2(4000) byte that contains comments that vary in length. Linefeeds are imbeded within the data. I am tr...
UPDATE duplicate row
Comments: 2
I'm looking for an UPDATE statement where it will update a single duplicate row only and remain the rest (duplicate rows) in Oracle or PL/SQL? Here is an example student table to work ...
Compare CLOB to a character in a SQL statement
Comments: 6
I have a SQL statement: select * from user_preferences a, employee b where a.user_id = b.employee_id and a.pref_value = 'N'; The problem is pref_key colum...
Select id of last record inserted
Comments: 2
I'm trying to selected the max id of the record just inserted to I can return it to the calling application. Do you I need to use a cursor?
PLS-00201: identifier 'SUBSCRIBER_NUMBER' mu…
Comments: 9
I'm trying to create a stored procedure and I get this error. Any ideas? Also, are there any other good practices I should include?
ODAC Version with .NET
Comments: 2
Hi, I am developing a software application that will work with Oracle 10g database. I want to take advantage of ODAC and ODP.NET, but am unsure if the latest version of ODAC that is targ...
Oracle 10g RAC Recovery
Comments: 2
I am trying to restore/recover Oracle 10g RAC prod database to an test environment with the same name and similar environment. The "restore database" completed successfully. Now when I am ...
Oracle 10g XE storage
Comments: 6
Hello! I'm a newbie in databases and I want to built a coldfusion application with oracle 10g xe behind. As Oracle xe is free for use, I was wondering what does 4 Gb of storage means for ...
what is use of parallel keyword
Comments: 6
what is use of parallel keyword in plsql? when we use parallel keyword in inserts, updates ..... what number(like parallel 12 11 ...) we can use, and how to decide on those...
use of parallel_enable in oracle functions
Comments: 4
when can we use parallel_enable in oracle function and can we use in all functions. what is the use of this clause.
What is the use of map function in oracle objects?
Comments: 3
What is the use of map function in oracle objects. please explain with example.
Oracle 10g RAC Restore
Comments: 2
I need to restore Oracle 10g RAC production database (A) to a test server (B) with the similar environment. The Disk Group numbers are different on both servers would this be of any concern? T...
SQL query
Comments: 12
Hi, I have sql query as follows: select * from table where status = ‘A’ order by datetimecolumn All they really want is the first row with a status of A in date order. Howeve...
How do I get a CLOB to come back in a UNION query?
Comments: 8
I need to use a CLOB in both ends of a query, and the CLOB may be empty in some cases. I cannot convert to VARCHAR2 because I need to be able to capture the full CLOB, not just the first 4000 ...
DBMS job to truncate table weekly
Comments: 13
Can someone please provide the syntax and steps how to schedule a DBMS job in oracle 11g database to truncate table weekly? Thanks.
rman catalog mode
Comments: 4
hi, any one can explain whats the diff b/w RMAN catalog and nocatalog mode
change job number in dba_jobs
Comments: 5
How can I change a job number from say 130 to 30 - 30 is not used by any other jobs. Oracle 10.2.0.4 on SUN solaris 64 bit
How to pass DATA_PARAMETER in Oracle Reports 10g f…
Comments: 6
I have a form (10g) which will pass a Record Group to the Report as a parameter list, but the report cannot be run. In the Form : A record group named 'Q_QUERY'with 2 colum...
update emp_no for the same dept_no
Comments: 1
For same dept_no, update emp_no to the min emp_no of that dept for all emp_name ='TEST'. Please see the following for before/after example. Thanks. BEFORE emp_no em...
Syntax help filtering data
Comments: 21
experts, I thought this would be easy but my results aren't even close. The following query returns 18 million rows: SELECT * FROM MEDICAL MED INNER JOIN U...
Interfacing and Difference between Materialized View and …
Comments: 13
Hi, We are building an interface between 2 databases. Our goal is to query the 2nd DB from the 1st and retrieve data from 2 to 3 tables. Another option suggested was a file transf...
How do I fix my query so that it doesn't return double resu…
Comments: 12
When I execute the following query I get the results twice. I am testing the query before I actually need to select records instead of a number count. So i am thinking if it gives me double count results it w...
Materialized View Error
Comments: 2
First off I would like to mention I am not proficent in Oracle what-so-ever but I can navigate around it semi-easily. The issue I am having is with 2 of my 8 materialized views when I click on thi...
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,920
0 points yesterday
Profile