concatenating rows of a column in oracle 9i sql
how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

Answer Question   |  February 16, 2009  10:17 PM
Concatenate, Oracle 9i, Oracle SQL

How to get started in a SQL Environment
I have been in an AS/400 world up until now. We are moving to SQL for a JDE EnterpriseOne implementation. What would be the best way for me to get up to speed on a SQL Server Database? Thank you for any and all insight.

Answer Question   |  February 12, 2009  3:26 PM
EnterpriseOne, JDE, SQL, SQL Database Training, SQL Server

New Contest: ASK, Answer and win some Amazon.com gift cards
It’s that time again — a chance to win an Amazon.com gift certificate based on your activity in the IT Knowledge Exchange community! Remember: the more you ask, answer and discuss questions, the more Knowledge Points you will earn. (Only valid questions, answers and discussions will be counted towards your total.) The top 10 most [...]

Answer Question   |  April 3, 2012  5:17 PM
AS/400, CIO, CRM, Data management, Database, DataCenter, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, VMware, VoIP, Windows

Oracle Reports6 Live Previewer
Hi I am using Oracle reports 6 to modify some reports first developed in an earlier version. My problem is that I do not get the editing toolbar showing when I run the report in Live Previewer. Is there some setting somewhere? However, If I develop a new report then the live previewer and all [...]

Answer Question   |  February 12, 2009  2:43 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports 6i Live Previewer

PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL
Hi Experts, How can we make a check on an attribute not null but can take – rather I have address 3 which can’t take null instead – would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN … END IF But i want to [...]

Answer Question   |  February 20, 2009  3:59 AM
NOT NULL, NULL, PL/SQL, PL/SQL procedure

Errors in Creating Oracle packages
Can anybody plz find out the error in the following code?? plz reply back. SQL> CREATE OR REPLACE package body PKG_IMAGEM1 2 as 3 PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, 4 P_College IN VARCHAR2, 5 P_CourseCat in varchar2, 6 P_CourseName in varchar2, 7 P_StudentName in varchar2, 8 P_ID in varchar2, 9 P_FileName in varchar2, 10 P_IMG IN [...]

Answer Question   |  February 9, 2009  1:04 PM
Creating Oracle packages, Oracle development, Oracle Package, Oracle SQL

PL/SQL – Attribute to test not null and can take specific value instead
Hi Experts, How can we make a check on an attribute not null but can take – rather I have address 3 which can’t take null instead – would be fine how this can be check n PL/SQL procedure

Answer Question   |  February 9, 2009  11:13 AM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL procedure

PL/SQL – How to make a check whether the attribute is positive or zero
Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

Answer Question   |  February 10, 2009  4:55 AM
Oracle PL/SQL, PL/SQL, PL/SQL attributes, PL/SQL Variables

Oracle vs Java programming
Which is better Oracle or Java? I have a interest in programming. What should I learn?

Answer Question   |  September 17, 2011  7:33 PM
IT career planning, IT careers, Java developers, Oracle development, Programming Careers

How Do I release unused space from a tablespace after dropping a blob table
I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles [...]

Answer Question   |  February 10, 2009  5:11 PM
BLOB, Oracle Tablespaces

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

PL/SQL error
Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

Answer Question   |  February 9, 2009  8:32 AM
ORA-08102, Oracle development, Oracle error messages, PL/SQL, PL/SQL error messages

Is my Oracle certification current enough?
I did my Oracle certification in developer track in April, 2001 (Oracle 8 with developer 6i). Is that certification still applicable or would I have to update? If updation required which online papers I would have to undertake.

Answer Question   |  February 4, 2009  8:34 AM
Oracle 8i, Oracle certifications, Oracle Developer 6i

Oracle: How to import schema to replace identical schema but retain unique identifier?
I have spatial (SDO) data that I would like to import from one schema into another identical schema. My problem is that I only want to replace the spatial data that have the exact same UID_1 (Unique Identifier). Is there a way to do this and if so how?

Answer Question   |  February 3, 2009  4:17 PM
Oracle identifiers, Oracle import/export, Oracle Schema, Oracle Spatial

Oracle archives are not moving from primary to standby database
Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?

Answer Question   |  February 3, 2009  4:10 PM
Backup, Database Backup, Oracle Archives, Oracle backup, Standby Database

IMP-00069 error on Oracle 8i dump import
Oracle 8i is loaded on two machines located at different places. If .dmp file taken from one machine is importing to another one, it gives the error imp-00069. I checked NCHAR charecterset with command “select * from nls_database_parameters;” on both machine and all 18 parameters are same on both. Can you please suggest how to [...]

Answer Question   |  February 3, 2009  4:07 PM
IMP-00069, NCHAR, Oracle 8i, Oracle 8i import/export

Need help creating a specific Oracle View
We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would prefer not to [...]

Answer Question   |  February 3, 2009  4:02 PM
Oracle development, Oracle Nested Tables, Oracle Views, VARCHAR

Oracle Data Dictionary
I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this information in [...]

Answer Question   |  February 18, 2009  3:59 PM
Oracle 10g, Oracle 10g Database, Oracle Data Dictionary, Oracle development

ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Answer Question   |  February 3, 2009  3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades