IT-Lösungen

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

Tom: I have a table that initially stores information about items in a warehouse stored in different bins. Table look like this where manual inventories are done every 3 months. Effective date is the sysdate when record is inserted. Inventory: Item_no Qty Bin Effective_Date AC006 10 DC001 2/1/2002 AC006 20 DC002 2/1/2002 AC006 100 DC001 5/1/2002 AC006 50 DC002 5/2/2002 AC006 30 DC003 5/3/2002 AC006 20 DC008 5/4/2002 I need to calculate two things: 1. Total Qty of an item in inventory in a given bin. which I basically did by taking qty of the item in inventory with the max(effective_Date)+total_received and stored in that bin since that max(effective_date) ? total shipped from that bin...
Weiterlesen...
Good Morning Tom. I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up in Rollback segment issue(s). Any suggestions please ! ! ! Murali
Weiterlesen...
Hello Tom, How to do a Full DB exp and Import. I do say exp system/manager@xyz FULL=Y FILE=FULL.DMP Then If I want to do a full Import to a new freshly created DB which only has the default schemas sys , system , etc. 1) Please correct me :- I would need to pre-create all schemas /tablespaces for those schemas needed to import the user and then do a FULL import. imp system/manager@abc FULL=Y FILE=FULL.DMP 2)Cant i just imp system/manager@abc FULL=Y FILE=FULL.DMP and the users and tablespaces will be automatically created due to FULL option ? 3)Is the use of FULL exp/imp just to gather all schema files into one big file. 4) Suppose I need to exp import say only 10 schemas. What is better peroformance wise, do a fromuser touser comma seperated list of owners or individually run 10 exp/imp commands. Are smaller individual files...
Weiterlesen...
Hi I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora) I have this in my tnsnames.ora POD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PODS.GATE.COM)(PORT = 1521)) ) (CONNECT_DATA = (SID = ODS) ) ) I can connect to the database if I use the command below, obviously the SQLPlus is refering the tnsnames.ora that I have) sqlplus USER/PASSWORD@POD However, if I do this, I will the error shown below. sqlplus USER/PASSWORD@//PODS.GATE.COM:1521/ODS ORA-12154: TNS:could not resolve the connect identifier specified Is there any way, I can connect to the database without refering to tnsnames.ora as defined in the TNS_ADMIN system...
Weiterlesen...
Hello Guru, Q1) I need to display numbers from a database in a specific format. Table Tn (n number(6,3)); The format is 999.999 SQL> insert into tn values( 123.123) ; 1 row created. SQL> insert into tn values(0) ; 1 row created. SQL>insert into tn values(0.123) 1 row created. So I do SQL> select to_char(n,999.999) from tn ; TO_CHAR( -------- 123.123 .000 .123 I need the display output of value which is .000 to be 000.000 AND .123 to be 000.123 as per the format mask. No matter what mask i give zero is always missing from the left hand side of the decimal. Or atleast I should have the display as 0.000 and 0.123. How to do this. 2)Can u send me the link for available format masks for numbers and dates in the DOC Please. Thanx
Weiterlesen...