Top "Oracle" questions

How to install SQL * PLUS client in linux

I am working on AWS services. I have an ec2 ( centos ) instance. I need to configure SQL*Plus client on …

linux oracle amazon-ec2 centos sqlplus

Updating CLOB field in Oracle

I have a table in Oracle database with field with data type CLOB. The name of field is XMLString. I …

oracle clob

SSIS - the value cannot be converted because of a potential loss of data

I am relatively new to SSIS. I am trying to extract information from an Oracle database using Microsoft OLEDB for …

sql-server oracle ssis etl

ORA-02019: connection description for remote database not found

I have created a db link AM_ADMIN throufh SQL Developer: I am trying to check if it is a …

oracle database-link

Data from two tables into one view

Is it possible to grab data from two tables (that have the same fields) into one view. Basically, so the …

sql oracle sql-view

How do you use telnet to check a connection to Oracle?

I've been trying to get sqlplus to connect to Oracle from my OS X machine. I asked another question about …

oracle telnet

Delete a child and a parent row with one SQL script

Instead of deleting the child row and then writing another sql statement to delete the parent row I wanted to …

sql oracle parent parent-child

Can you SELECT everything, but 1 or 2 fields, without writer's cramp?

Is it possible, in PLSQL, to select all of the fields in a table except for 1 or 2, without having to …

oracle plsql

What are the major differences between the mysql and oracle sql dialects?

I am a software developer. I have used mysql for years and now I am about to have my first …

mysql sql oracle dialect

Select into a temporary table in Oracle

I am trying to do something like the following, select * into temp from (select * from student); It gives me the …

oracle plsql sqlplus