1
  • How to display non existent data as 0 in Oracle

    in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so...

    Deb4u50 pointsBadges:
  • Temp table with months in Oracle

    How do I create temporary table which contains all the months from January to December?

    Deb4u50 pointsBadges:
  • how delete 12,33,200 rows in oracle table

    how delete 12,33,200 rows in oracle table

    Shindetanaji10 pointsBadges:
  • 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 table_name = 'TABLE1'; But...

    Mkaminski20 pointsBadges:
  • select command

    i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.

    23523523595 pointsBadges:
  • how to transfer oracle table data to .csv file by using pl/sql coding

    how to transfer oracle table data to .csv file by using pl/sql coding

    Tarick215 pointsBadges:
  • oracle

    how to find the difference between structure of the table?

    GOBIKKANNAN5 pointsBadges:
  • How can I run a SAS program in mainframe that calls Oracle in Unix

    Hi, I need to run my SAS program in z/OS which call Oracle in Unix to retreive data from Oracle table. I tried this SAS program in PC SAS without any problem. How do I connect to Oracle in my SAS prgram in z/OS? Need help, please    

    Tl312820 pointsBadges:
  • To display not exit data in oracle

    in my table there a,b,c,d are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose b & c are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month as 0...

    Deb4u50 pointsBadges:
  • ordering dates in Oracle

    how to order the months and year in descending order from a table?suppose there are 2 culomns one contains month and another contains year.then how to show them in an order like jan-2001,feb-2001,mar-2001.........like this. plz suggest some answer for this.

    Deb4u50 pointsBadges:
  • ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g

    I was trying to create a table with primary key based on two columns. Here is the create table statement: CREATE TABLE SECURITY_PASSWORD ( USER_NAME VARCHAR2 (25 BYTE) NOT NULL, USER_PASSWORD VARCHAR2 (25 BYTE) NOT NULL, CREATED_DATE DATE NOT NULL, CONSTRAINT security_password_pk PRIMARY_KEY...

    Techguys90 pointsBadges:
  • Oracle Forms 10g code

    how to show all empid in list item in oracle form during the runtime... pl give me details with code. table structure is    create table dept( empid int,ename varchar2(20)); gv me full code of the  under the form_instance_click.........                             

    Oracleform10 pointsBadges:
  • 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...

    Dug50 pointsBadges:
  • 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

    SamAvella30 pointsBadges:
  • 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...

    Radupopa5 pointsBadges:
  • 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...

    Ss20095 pointsBadges:
  • 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...

    Hmhora10 pointsBadges:
  • 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 an...

    Ejpeth15 pointsBadges:
  • 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 one...

    AGDAVA35 pointsBadges:
  • 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 this...

    JoeA15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following