We have upgraded our 7.1.6 Oracle server to 7.3.3 and from this point, we
have a performance problem on the set role sql insrtuction. We have an
application that set enable 10 roles.
With version ...
http://www.experts-exchange.com/Database/Oracle/Q_10037460.html
Zones:
OracleDate Answered: 03/02/1998 Grade: A Views: 0
I am trying to get the following queries for the listed table schemas:
EMPLOYEE(SSN,NAME,ADDRESS,AGE,SEX,SALARY,SUPERSSN,DNO)
DEPARTMENT(DNAME,DNUMBER,MGRSSN,MGRSTARTDATE)
PROJECT(PNAME,PNUMBE...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10204519.html
Zones:
DatabasesDate Answered: 03/15/2002 Grade: A Views: 0
The question in simple words is that:
i want to capture the execution command syntax "BEFORE EXECUTION" whatever the source is of the command is (SQL PLUS, already made application, .... etc).
...
http://www.experts-exchange.com/Database/Oracle/Q_10211133.html
Zones:
OracleDate Answered: 10/20/1999 Grade: A Views: 0
I'd like to create a general procedure:
append(p_filename,p_SQL,p_format)
where p_SQL is any select statment and p_format is either HTML or MONOTEXT and if the format is html it appends the r...
http://www.experts-exchange.com/Database/Oracle/Q_10353069.html
Zones:
OracleDate Answered: 05/24/2000 Grade: A Views: 0
Hello,
1)
I want to be able to "log" the SQL that client sends to the oracle server through the listener.... is there a way to adjust the listener config file to log the sql submitted from the ...
http://www.experts-exchange.com/Database/Oracle/Q_20041133.html
Zones:
OracleDate Answered: 02/06/2001 Grade: A Views: 0
How is the SQL SELECT statement executed?
I want to know the functioning of SELECT statement at a deeper level.
Can anyone give an internal working of SELECT statement?
Particularly I wo...
http://www.experts-exchange.com/Software/Internet_Email/Email/Email_Clients/Q_20114546.htm...
Hi,
Using Ultradev I am querying an mdb to retrieve records based on date. I use a clause as below to do this:
SELECT *
FROM USERS
WHERE DOB = #01/01/01#
Everything works OK and the reco...
http://www.experts-exchange.com/Web_Development/Software/Macromedia_Dreamweaver/Q_20144369...
Hi,
I use Oracle 8.1.6 Enterprise edition on my machine.
The problem is when i restarted the machine i got an error 1033-oracle initialization or shutdown in progress
I cannot login into sql...
http://www.experts-exchange.com/Database/Oracle/Q_20243891.html
Zones:
OracleDate Answered: 04/27/2002 Grade: A Views: 0
I am new to SQL Server programming, I normally use Oracle so here is my question. I have a table named inventory with a primary key (ID)and a column named prop_num, the other columns don't matter ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20355163.html
While converting a stored procedure from SQL Server to Oracle, I need a function to replace the following CASE statement (I am using 8i so cannot use the case in PL/SQL):
CASE
...
http://www.experts-exchange.com/Database/Oracle/Q_20559775.html
Zones:
OracleDate Answered: 03/23/2003 Grade: A Views: 0
