Hi all,
In oracle when we wright stored procedures the language is called pl/sql. when we write a stored procedure in sql server what is the lanugage? Is it just called SQL?
Thanks!
Hi all,
Like in Oracle 8i database server where we have a utility called DBA Studio to administor database and its users, what is the utility for SQL Server 7.0?
Hi all,
I have never loaded data into SQL Server 2000.
I have a dumpfile with a .bak extension. I need
to load the data into a database.
What is the process?
Thanks!
HI all,
I have microsoft access 2000 and import table from microsoft excel. Now I'm trying export the table into Oracle 8.1.7 but I keep getting the ODBC error. However using the same ODBC I could connect to the Oracle database and link tables.
What is going on?
Hi all,
Why we use REFERENCING in a trigger?
The following trigger contains the REFERENCING clause:
CREATE OR REPLACE TRIGGER C_BIR
BEFORE INSERT
ON schema.c_table
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
SELECT c_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
What does the...
Hi all,
How can you add a primary key to an existing table?
The structure is like this:
CREATE TABLE [dbo].[TEST1] (
[ID] [int] NULL ,
[NAME] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
Now I need to modify the test1 table so that ID column will be the Primary key? Also how can...
Hi all,
One of our clients complained that when they imported data from Oracle 8i to SQL Server 2000 the constraints got lost.
Is this possible?
Thanks!
Has Anyone used PVCS Traker? We have the tracker installed in the one of the computers. It used the SQL Server as the backend. But I'm not sure where all the data files are save.
Thanks!
HI all,
Logic of the script is listed below. Now I'm not sure if I could do this with a SQL or I have to write PL/SQL.
Anyway this is how the script looks like:
SELECT one_step_before_Last(STATION_POINT.MEASURE) AS LastOfMEASURE,
one_step_before_Last(COORDINATE.X_COORD) AS LastOfX_COORD...
Hi all,
I have linked a table that is in Oracle 8.1.7 through access 2000. I realized its not an access forum, but I think someone might have experiance this problem one time or another.
Well the problem is I linked the table though the access gateway. When I try to update the id column to...
Hi all,
I have linked a table which is located in Oracle 8.1.7. I realized its not an oracle forum, but I think someone might have experiance this problem one time or another.
Well the problem is I linked the table though the access gateway. When I try to select the column to change a value...
Hi all,
I have linked a table which is located in Oracle 8.1.7. I realized its not an oracle forum, but I think someone might have experiance this problem one time or another.
Well the problem is I linked the table though the access gateway. When I try to select the column to change a value...
Hi all,
I have a whole bunch of tables that have columns that are varchar. I want to check for any double space within the string. Also for any space in front of the string or at the end of a string.
I know I could check like this:
WHERE (DESCRIPTION LIKE '% %' OR DESCRIPTION LIKE ' %' OR...
Hi all,
I have 3 log group and the size is 1024K. Now the database is experiancing performance issue. Also in the log file I see the 'checkpoint not complete ' error. So I want to add more log groups.
The script look something like this:
ALTER DATABASE ADD LOGFILE GROUP 6...
HI all,
In the plan_Table I see that one of the table is doing a full scan to retrive infor.
The view look something like this:
CREATE OR REPLACE VIEW V_DRAWINGS (LINE_ID,
LN_DESIG,LINE_NAME,ROUTE_ID,ROUTE_NAME,SHEET_NAME,
EVENT_ID,EREP_ID,STATION_BEGIN,STATION_END,MEASURE_BEG...
Hi all,
I need to check if a set of views exist in the dictionary.
My code is as follows;
Basically, I'm selecting list of view_names from a table where the names are stored.
Then I need to check if those views exist in the data dictionary. I have to use all_objects dictionary b/c of...
Hi all,
string 1:'abc def'
string 2:'abcdef '
I know checking space between a string (string 1) is easy. But how do you check for a trailing space in the string 2?
Thanks!
Hi All,
I am in the oracle enterprise manager console administrator. I have logged in an sysman. Now what I'm trying to do is setting up the preferred credentials. I'm sort of confused in this step. I selected the database and node in the preferred credentials and used the system user with the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.