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.

Answer Question   |  March 22, 2012  7:49 AM
Oracle, Oracle commands, Oracle Table

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

Answer Question   |  March 14, 2012  7:14 AM
.CSV files, Oracle, Oracle Table

oracle
how to find the difference between structure of the table?

Answer Question   |  February 28, 2012  2:37 AM
Oracle Schema, Oracle Table, Toad Data Modeler

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    

Answer Question   |  August 13, 2010  7:12 PM
Mainframe, Oracle, Oracle Table, SAS, SAS programming, Unix, z/OS

Temp table with months in Oracle
how to create temporary table which contains all the months from january to december

Answer Question   |  August 11, 2010  4:31 AM
Oracle, Oracle Forms, Oracle Table, Oracle Tables

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 how to show them for that month [...]

Answer Question   |  August 11, 2010  3:37 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table

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 [...]

Answer Question   |  August 10, 2010  4:07 PM
Oracle, Oracle commands, Oracle database design, Oracle Table

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.

Answer Question   |  August 9, 2010  3:49 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table

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 (user_name,user_password) ); Unfortunately I keep getting error message: ORA-00902 invalid datatype.This is [...]

Answer Question   |  June 26, 2010  5:12 PM
CREATE TABLE statement, Database issues, Oracle 10.2.0.4, Oracle 10g error messages, Oracle Table

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………                             

Answer Question   |  June 22, 2010  6:30 PM
Oracle 10g, Oracle Forms, Oracle Table

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 views. Does [...]

Answer Question   |  July 21, 2009  1:38 PM
Oracle, Oracle Table, Oracle Tablespaces

how delete 12,33,200 rows in oracle table
how delete 12,33,200 rows in oracle table

Answer Question   |  May 3, 2012  9:04 AM
DELETE statement, Oracle Table

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

Answer Question   |  March 31, 2009  2:26 PM
Oracle, Oracle Table

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 from [...]

Answer Question   |  March 12, 2009  7:10 PM
Oracle Table, Oracle Unique ID

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 structure (including ordering of columns) to be identical [...]

Answer Question   |  February 10, 2009  5:08 PM
Data Replication, Oracle Stream Data Replication, Oracle Streams, Oracle Table

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 [...]

Answer Question   |  February 5, 2009  5:01 PM
Oracle Table, Oracle Table Size

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 UPDATE of [...]

Answer Question   |  December 23, 2008  3:49 PM
MERGE statement, Oracle Table, PL/SQL, SET/WHERE

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 the WHERE [...]

Answer Question   |  April 20, 2012  2:39 PM
Oracle Database, Oracle Table, Oracle Table Comments

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 [...]

Answer Question   |  November 13, 2008  2:14 AM
Oracle 8, Oracle 8 performance, Oracle performance, Oracle Table

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 string, so in the case above I need to replace the substring 2,2 with [...]

Answer Question   |  October 24, 2008  9:06 PM
Oracle PL/SQL, Oracle Table, VARCHAR