Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mkey
  • Content: Threads
  • Order by date
  1. mkey

    pl/sql vs sql server procedures

    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!
  2. mkey

    SQL Server 7.0

    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?
  3. mkey

    load data

    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!
  4. mkey

    ODBC failed error,urgent!

    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?
  5. mkey

    trigger question

    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...
  6. mkey

    add a primary key and foreign key

    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...
  7. mkey

    import data from Oracle 8i and constraints lost

    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!
  8. mkey

    PVCS traker

    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!
  9. mkey

    sql script help

    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...
  10. mkey

    This recordset is not updateable

    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...
  11. mkey

    Updating in microsoft 2000n,urgent

    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...
  12. mkey

    Updating in microsoft 2000n,urgent

    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...
  13. mkey

    doublespace to a single space

    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...
  14. mkey

    log groups,'checkpoint not complete ' error

    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...
  15. mkey

    retrieval of views

    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...
  16. mkey

    pl/sql help,urgent

    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...
  17. mkey

    how to check a trailing space in a string,urgent!

    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!
  18. mkey

    select non empty tables

    Hi all, I need to write a script that will select all the tables in a specific schema where the tables are not empty. Any thoughts? Thanks!
  19. mkey

    oracle 9i odbc driver compatability,very urgent!

    Hi all, Is Oracle 9 odbc driver is compatable with oracle 7 server? Thank!
  20. mkey

    setting up preferred credentials

    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...

Part and Inventory Search

Back
Top