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 Westi 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: ksr
  • Order by date
  1. ksr

    Manually Un-installing Oracle 8.0.5

    Thanks Mufasa, I am working on Windows NT4
  2. ksr

    Manually Un-installing Oracle 8.0.5

    I am working on Oracle 8.0.5. Sometimes when I start the machine, I get Error - > ORA-1034-Oracle Not Available. What could be wrong? How can I manually remove Oracle 8.0.5 from the system?
  3. ksr

    TNSListner80 does not Start

    To access the Oracle Database through the client, the TNSListener80 service must be started but on my Server machine, the TNS Listner Service is not working and still I am able to perform all the functions on the database. How is it possible?
  4. ksr

    Searching All the Tables for a Value

    I have a number of tables in the Salary Database. I want to modify the Salary of some employees. Is is possible through SQL, to search each table for the existence of Employee, say, ECode= 453. Incase the Employee exists, disable the constraints applicable on the table, modify his Basic Salary...
  5. ksr

    Oracle ROWID Question

    Does Import / Export of Database, change the Internal RowID of Data being maintained by Oracle. Does installing a new version of Oracle, changes the RowID of Data already entered through the lower version.
  6. ksr

    tablespace growing constantly

    Hello I am faced with a wierd problem. The tablespace of my database is growing contantly and is nearing the limit. What needs to be done? How can I reduce it? Can it lead to Oracle crash. Any suggestions. I am new to databases. Thanks ksr
  7. ksr

    Character by Character Scan of a long text field

    I have a Table having "Security" field as VARCHAR2(2000). The contents of this field are something like "2-3//4; 1/2MIN; 3/4-5MIN MIN; 2&3//5/6 3/4-5MIN 1-2/3//4-5;" and so on. There may or may be delimitters like ";" above. The input in the Table is coming from a Security Form designed in VB6...
  8. ksr

    Character field updation help required

    I have a Cutomer Table having Customer Ids as "123 J","342-J","786","876/J","453 JAL". I want to update this Table and all other Tables wherever the pre-updated value of "CustomerId" exists in the Database with only the Numeric portion of CustomerId concatenated with 3 character code like "JAL"...
  9. ksr

    Checking Column Existence in all the Tables of Database

    Is it possible with a single SQL Statement to know the names of all the tables having column "MemberID" and check the existence of "MemberId - 2365NRM" is all the scanned tables.
  10. ksr

    Numeric Sorting a Character field

    I have a Members Table having a column name as "MemberId", which is of varchar2 datatype. The MemberIds contained in the Table generally are "1NRM", "2NRM","3NRM" and so on. Now when I sort the Table on MemberId, the sorting output comes as...
  11. ksr

    Comparison between CISCO 2620 & CISCO 3620

    Dear Sir, I am working in an organisation whose area of operation spreads all over the state. It has got 85 branches (presently, likely to expand) located at far distances, all over the state. Each branch shall have One Server and three other networked computers with modem connected to the...

Part and Inventory Search

Back
Top