How can we apply AVG, COUNT, MAX, MIN, NUMBER, STD, SUM and VARIANCE functions in COMPUTE command. I am not getting the correct results.
For RECOVER command can you ...
http://www.experts-exchange.com/Database/Oracle/Q_20281158.html
Zones:
OracleDate Answered: 03/26/2002 Rating: 9.8 Views: 0
hello everyone,
I am a student and i have a basic doubt.
I installed Oracle on a Windows98 machine as a stand alone application.
I am not able to login coz i dont know what the host string mean...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20564431.html
Zones:
DatabasesDate Answered: 02/22/2004 Rating: 7.4 Views: 0
I HAVE A TABLE NAMED: EMP
TWO COLUMNS: ENAME AND 1RST_OCCUR.
I MUST FIND THE FIRST OCCURRENCE OF 'L' IN ENAME AND CHANGE IT TO 'X'.
SAMPLE:
ENAME 1RST_OCCUR
-------- ...
http://www.experts-exchange.com/Database/Oracle/Q_20781479.html
Zones:
OracleDate Answered: 10/31/2003 Rating: 7.6 Views: 9
I have a table emp , one of it colum name is companyname(varchar2), empname .
companyname can contain null rows.
Question :: How I can find the empname from emp who are not assigned to any comp...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23029292.html
I am creating a view in SQL PLUS. The view is using many table. I want to use a create a calculated field based 2 dates fields (one of which is displayed in the view and one that is not).
Righ...
http://www.experts-exchange.com/Database/Oracle/Q_23112183.html
Zones:
OracleDate Answered: 03/01/2008 Rating: 8.8 Views: 96
I'm doing a small database migration.
I use a staging table to put temporary data before putting it in the new databse.
I've look at it the whole day. THe WHERE condition is wrong :(
select ...
http://www.experts-exchange.com/Database/Oracle/Q_23236809.html
Hi,
I have 2 tables A and B.
A has email addresses (example: abc@infinata.com) and B has domain names (example: infinata.com)
I want to find out a sql query that would remove all email addre...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23257375.html
I'm running a SQL Plus command with parameters and they are working correctly, but when I look at the spool output, the first 2 lines are showing the replacement of the variables to the passed para...
http://www.experts-exchange.com/Database/Oracle/Q_24048150.html
Hello Experts,
I am using the following script in SQL PLUS:
select 'SELECT count('||column_name||')
from '||table_name||' ;' from all_tab_columns
where owner = 'OWNER NAME'
which generates ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24448540.html
What SQL statement do I use to get a list of all columns in a table along with a count of the values in each column? I'm using SQL plus and I'm querying an Oracle database.
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24454391.html
Zones:
SQL SyntaxDate Answered: 06/01/2009 Rating: 6.9 Views: 0
