• Disable all table constraints in Oracle

    Would I be able to disable all the table constraints in Oracle using one single command? It doesn't matter what table it is. It can be for a a single table, list of tables or for all tables. Thanks so much!

    ITKE352,580 pointsBadges:
  • To delete the duplicate record from Oracle table.

    How do I delete the duplicate a record from an Oracle table? Please provide the command.

    Least5 pointsBadges:
  • How to find duplicate records in an Oracle table

    How do I find duplicate records in a table?

    gettosrinivas35 pointsBadges:
  • How to insert a UPSERT operation into an Oracle table

    I understand that UPSERT operation either updates or inserts a row into a table (depending if the table already has a row with matching data). Here's the code: if table t has a row exists that has key X: update t set mystuff... where mykey=X else insert into t mystuff... But in Oracle, it doesn't...

    ITKE352,580 pointsBadges:
  • How to add a boolean field to an Oracle table

    This past week, I've wanted to add a "Boolean field" to one of my Oracle tables. But I noticed that there's no boolean data type in Oracle. Is there a way to simulate it? A friend of mine told me to "Use an enum with the CHECK restraint." Is that the way to go?

    ITKE352,580 pointsBadges:
  • Writing a SQL query for an Oracle table

    We have this data in an Oracle table (here it is below): MONTH VALUE 1 100 2 200 3 300 4 400 5 500 6 600 So we need to write a SQL query so the results are showing like this: MONTH_JAN MONTH_FEB MONTH_MAR MONTH_APR MONTH_MAY MONTH_JUN 100 200 300 400 500 600 Any help would be appreciated.

    ITKE352,580 pointsBadges:
  • Creating a copy of an Oracle table without the data

    Would it be possible to create a copy of an Oracle table without actually copying the data? I believe I already know the statement: create table xyz_new as select * from xyz; But I think this copies both the structure and the data. I'm just trying to get the structure. Thanks!

    ITKE352,580 pointsBadges:
  • How to transfer Oracle table data to .CSV file by using PL/SQL coding

    How do I transfer Oracle table data to .CSV file by using PL/SQL coding?

    Tarick215 pointsBadges:
  • 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:
  • oracle

    how to find the difference between structure of the table?

    GOBIKKANNAN5 pointsBadges:
  • Temporary Table in Oracle 10g

    create global temporary table transaction_tab     --on commit delete rows     as SELECT * FROM CUSTOMERTELEPHONYSERVICE WHERE 0=1;     commit;     insert into transaction_tab SELECT * FROM CUSTOMERTELEPHONYSERVICE WHERE CUSTOMERTELEPHONYSERVICEID = 1;               select *...

    Salmanra5 pointsBadges:
  • To Specify the location for New Column in Oracle

    Why it is not possible in Oracle to specify the location for any newly added column. why it always goes to the last.  I know we can do the same using MySQL.  Is there any option/chances in the up coming versions of Oracle

    Maheshmamu20 pointsBadges:
  • ORA-1555 insert table with 3 billions rows in Oracle with SQL

    I have a big table with 3 billions rows and would like to rebuild in a less period of time as possible. I ran 3 plsql scrits , each plsql script is doing a full table scan to get 3 diferente range of data and insert in a new table , the commit in the cursor is for each 200.000 rows ( forall ) ,...

    Mrosa0015 pointsBadges:
  • Oracle Reports 6i tables

    Hi All, I am working in Oracle 6i reports, I want to hide some report columns value at runtime. For example if dataentry operatior run a invoice report the value columns are print like '**********' otherwise it will print original value. The users are controlled in a seprate table. Using that table...

    Kathiravan5 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:

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