I'm trying to run a command file via SQL*plus from the command line - it almost works seamlessly but when sql*Plus loads it sits and waits - if I then press enter it executes the commands in the co...
http://www.experts-exchange.com/Database/Oracle/Q_23158532.html
Zones:
OracleDate Answered: 02/28/2008 Rating: 7.4 Views: 18
I am using SQL statements and outputting the results on an output file. It seems that the "SQL>" tag appears after every type of SQL statement. Is it possible to have an output file not display t...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23187507.html
I have a sql query that contains the state and cities (major) that are in that state
STATE CITY
-------- -------
CA Los Angeles
CA Oakland
CA San...
http://www.experts-exchange.com/Database/Oracle/Q_23207905.html
Zones:
OracleDate Answered: 03/02/2008 Rating: 9.0 Views: 0
my select statement is pulling state_id & state_name from 2 tables. I'm creating a view that is picking both state_id & state_name sets as part as my column listing
i want my create view to loo...
http://www.experts-exchange.com/Database/Oracle/Q_23208508.html
Zones:
OracleDate Answered: 09/21/2008 Rating: 9.2 Views: 0
I'm trying to make my CTL file insert an "N/A" if it incounters a NULL or blank value. I need help.
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23740103.html
The sql plus script and process has been working perfectly for a year and all of a sudden when I run it, the script doesn't pull all of the data. When I have someone else run it on their laptop wi...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_24003783.html
Zones:
PL / SQLDate Answered: 12/31/2008 Rating: 8.2 Views: 0
Hello,
I'm having an introductory DBMS course in oracle. I have only 3 tables for testing the SQL commands. In addition, we use SQL *Plus interface, the one we've created the tables with and appl...
http://www.experts-exchange.com/Database/Oracle/Q_24348596.html
Zones:
OracleDate Answered: 04/23/2009 Rating: 9.0 Views: 0
Hello Experts,
Is there an efficient way to determine whether or not fields in the tables in an Oracle database contain data or not...this needs to be determined for all of the tables in the datab...
http://www.experts-exchange.com/Database/Oracle/Q_24457217.html
Implement the distributed database system based on the student database.
Horizontal partition distribution to distribute the CS dept student info in one site(oracle3) and Math dept. student info i...
http://www.experts-exchange.com/Database/Oracle/Q_24541795.html
Zones:
OracleDate Answered: 08/06/2009 Rating: 9.6 Views: 28
Need SQL/oracle statement to join two tables that don't have like columns. i.e.
Table 1
Column 1 Column 2
Table 2
Column 3 Column 4
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24838900.html
