1
  • Temp table with months in Oracle

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

    Deb4u50 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:
  • 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:
  • use of external tables oracle 10g

    use of external tables along with its parallel ability

    Nip5 pointsBadges:
  • Oracle table update exist ?

    dear all, i want implemente a update on many table but i don't know the syntax please help me. My update is at less on 5 table

    Tchywallace220 pointsBadges:
  • Data issue in a Oracle Table

    I have a 180 GB size table. When I select the table,it returns some columns with null data. But if I Select that particular record showing NULL column with a Primary key filter,it is showing data for that column. Please let me know what might be the problem with that table.

    Ctnaveenkumar25 pointsBadges:
  • Exporting Oracle 9i tables

    I have installed Oracle 9i server on Windows 2000 and clients on other machines. The database name is admin. I have created tables in my own login ora102 on the client machine. Now I want to export the tables which I have created in my own login. I used the following command on theclient machine to...

    ITKE343,740 pointsBadges:
  • how can we change Oracle text fields in a tabular form to a row and columns

    how to convert the oracle text fields into table in an oracle form

    Sthota5 pointsBadges:
  • Oracle 10g Query

    i made two tables in oralce10g,income and expense they have no relation with each other plz tell me a query how can i get the data from these tables with one query.

    Zaman31502110 pointsBadges:
  • Oracle- Parsing data in a specific row into a temp table

    I have used select text from dba_views where owner = 'Something' and view_name = 'Something'; I get back a row with the word (MEMO) in it. However that row contains a lot of text when clicked on. Such as something like SELECT /* SCCS Rev 1.1 10/14/2002 by Blah SCCS Rev 1.2 10/24/2002 Blah SCCS Rev...

    Dug50 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