Recent IT Questions

1 - 10 of 10
<<PREVIOUS 1 NEXT>>

Oracle- Source Code for Tables and Views cannot find

Hey, I am working on some coding to find a certain phrase with a number like (SCCS Rev 1.13) in the comments within procedures, tables, views, packages, etc. It works for everything except Tables and Views. This is because i am using Dba_source which does not include the source code for table or...

View Answer   |  Jul 21 2009  1:38 PM GMT
Oracle, Oracle Table, Oracle Tablespaces
asked by Dug

  45 pts.

how delete 12,33,200 rows in oracle table

how delete 12,33,200 rows in oracle table

View Answer   |  Jul 8 2009  9:04 AM GMT
DELETE statement, Oracle Table
asked by Shindetanaji

  10 pts.

Multiple Updates

Hi, is there a way to update a table as follows: update tabe_name set name=name1 where oldname=1 name=name2 where oldname=2 name =name3 where oldname=3; Thanks, Sam

View Answer   |  Mar 31 2009  2:26 PM GMT
Oracle, Oracle Table
asked by SamAvella

  25 pts.

oracle: creating unique ID in a table

Hi there, I have a huge table (hundreds of millions rows) with this structure: call_id, date, cust_id. The PK is cust_id + call_id, so call_id is unique for each cust_id. I need to update call_id to be unique in whole table and sequential when table is ordered by cust_id and date. Values can come...

View Answer   |  Feb 26 2009  7:10 PM GMT
Oracle Table, Oracle Unique ID
asked by Radupopa

  5 pts.

Does Oracle Stream data replication requires identical tables structure between source and Target Databases?

We are considering the use of Oracle Data Stream to replicate data from operations database to a separate Helpdesk database. Our users require near real-time data loaded in the helpdesk database. What are the constraints imposed by Oracle streams for table design? Does it require for tables...

asked by Ss2009

  5 pts.

Calculate SIze of Oracle Table with BLOB column and BLOB Index

I have a 30 GB table with BLOB column and BLOB INDEX. However, when I used Toad to look at the BLOB INDEX, it is a system generated and have NO COLUMN. Question 1: How do I calculate the actual size of thhe BLOB table, BLOB index, etc ... Question 2: How do I determine if this BLOB table and BLOB...

Answer Question   |  Feb 5 2009  5:01 PM GMT
Oracle Table, Oracle Table Size
asked by Hmhora

  10 pts.

Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables

Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in...

View Answer   |  Dec 16 2008  3:49 PM GMT
PL/SQL, MERGE statement, Oracle Table
asked by Ejpeth

  15 pts.

How does one COMMENT a table ONLY if it has NO comment?

I am importing comments on 1500 tables from a separate source. I would like to put a comment on each table ONLY if one does not currently exist (COMMENTS field is NULL). A command like: COMMENT ON TABLE owner1.table1 IS 'Test 4 adding comment' WHERE owner = 'OWNER1' AND...

View Answer   |  Dec 4 2008  2:39 PM GMT
Oracle Table, Oracle Database, Oracle Table Comments
asked by Mkaminski

  20 pts.

Need to update nearly 3cr rows in Oracle table

HI , My database is oracle 8.0 vesion.i need to update the customer_id in in table with new_customer_id. for the smaller table my simple update is working fine .. when i fired the same update for the big tables ( 30000000 rows), its running for 10 hrs and failing with rollback segments. can any...

View Answer   |  Nov 13 2008  2:14 AM GMT
Oracle performance, Oracle 8, Oracle Table
asked by AGDAVA

  35 pts.

Replace a variable part of a string in a varchar2 field

I have a vendor Oracle table containing data as follows column name: PVC_Value value = TRKCASETRK;6,0,0,0,0,0,0;;20801911;32004910;43175007;2,2;0;59647;1,30;0;0;3002 As you can see this field contains data delimited by semi-colons (for 13 elements) I need to relace the 7th and 10th elements in...

View Answer   |  Oct 23 2008  9:06 PM GMT
Oracle PL/SQL, VARCHAR, Oracle Table
asked by JoeA

  15 pts.

1 - 10 of 10
<<PREVIOUS 1 NEXT>>