IT-Lösungen
Die Entwicklung individueller Lösungen ist auch in Zeiten moderner Begriffe wie Cloud, Mobil oder Web ein wesentlicher Aspekt aktueller Anforderungen heutiger EDV-Projekte.
Gewachsene Strukturen, verteilte operative Systemkomponenten und speziell zugeschnittene Standardlösungen sind die Herausforderungen bei der Weiter- oder Neuentwicklung moderner Anwendungen. Basierend auf Methoden moderner Oracle-Technologie realisieren unsere Mitarbeiter "Ihre Anwendungen" die webbasiert und für unterschiedliche Endgeräte geeignet sind. Egal ob intern, über das Internet, auf dem Tablet oder dem Smartphone überall ist eine Nutzung möglich.
Schwerpunkte unserer Dienstleistungen sind:
• Daten-Modellierung (ERM) und Daten-Migration
• Konzeption und Entwicklung
-
- Professionelle Softwaresysteme mit Oracle Application Express (APEX)
- Professionelle Softwaresysteme mit Oracle Forms & Reports
- Migrationen bestehender Lösungen auf Oracle Technologie
- PL/SQL- basierte Datenbankprogrammierung
• Installation und Konfiguration
- Oracle Datenbank-Software
- Oracle Middleware
• Performance-Optimierung
AskTom News
ORA-12560: TNS:protocol adapter error 01.12.2024 21:08 i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error "
what should i do?
please help..
(scott/tiger) Weiterlesen... |
IN (vs) EXISTS and NOT IN (vs) NOT EXISTS 01.12.2024 21:08 Hi Tom,
Can you pls explain the diff between IN and EXISTS and NOT IN
and NOT EXISTS. Because I have read that EXISTS will work better than
IN and NOT EXISTS will work better than NOT IN (read this is Oracle
server tunning).
Regards,
Madhusudhana Rao.P Weiterlesen... |
Converting CLOBS TO VARCHAR 01.12.2024 21:08 Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors Weiterlesen... |
Difference between Full Index Scans and Fast Full Index Scans 01.12.2024 21:08 Hi Tom, What is the difference between Fast Index Scan and Fast Full Index Scan ?
As per oracle documentation,
" A full scan is available if a predicate references one of the columns in the index. The predicate does not need to be an index driver. A full scan is also available when there is no predicate, if both the following conditions are met:
?All of the columns in the table referenced in the query are included in the index.
?At least one of the index columns is not null.
A full scan can be used to eliminate a sort operation, because the data is ordered by the index key. It reads the blocks singly.
Fast full index scans are an alternative to a full table scan when the index contains all the columns that are needed for the query, and at least one column in the index key has the NOT NULL constraint. A... Weiterlesen... |
Finding the number of rows in each table by a single sql 01.12.2024 21:08 hi tom
i have a databse with 125 tables. i can find the total number of tables of the database by the sql
select * from tab; now i would like to know the number of rows in each table of my database with out
executing select count(*) from...; each time.
please help me
sincerely
rajesh Weiterlesen... |
- 1
- 2