Search results for query: *

I'm more of a software guy and is new to networking. Nonetheless, here is the situation now... == A small and very traditional company with a HQ office and 5 branch office. They are not networked at this point in time. HQ office have around 10 PC with no network. HQ also have 2 printers...

how can I retrieve a sysdate value and display it in date and time? I have a simple table "test" with a field datetime and datatype date. I do an insert as follows: == insert into test values (sysdate); == now, I want to retrieve the value and use it to insert into another table...

when deleting from a record from a table... how can I lock it for delete. I tried something like that.. == select emp_no from employee where emp_no = '1' for delete nowait; == in SQLPlus, it gives me an error message === ERROR at line 1: ORA-00905: missing keyword == What could be wrong?

I have a stored procedure as follows: === Procedure Count_Offences ( p_sdate IN date, p_edate IN date, p_off_cur IN OUT OffencesCurTyp) AS BEGIN OPEN p_off_cur FOR SELECT DEMERIT_CODE, count(*) FROM offence WHERE off_datetime between to_date(p_sdate, 'YYYY-MM-DD') AND to_date(p_edate...

ok, I am not sure whether this is the alert log. But I do find some form of log file at this location... C:\Oracle\admin\mugca\bdump\mugcaALRT.LOG "mugca" is my database instance. and the last entries in the log file shows 18 April. I have since rebooted the machine a couple of...

where is alert log? thanks

Also, from Toad, I got the following messages... ================ Details: oci.dll found 2) Oracle Home Key is SOFTWARE\ORACLE\HOME0 Looking for TNS_ADMIN environmental variable TNS_ADMIN environmental variable doesnt exist, looking for TNS_ADMIN reg key using home key...

I got the following error while trying to logon via SQLPlus. I have check the services and only one is not started. ==== OracleOraHome81Agent Started Automatic OracleOraHome81ClientCache Started Automatic OracleOraHome81DataGatherer Started Automatic...

I have a table as follows and need a procedure to return, given a start date, end date, a count of all offences group by demerit code == Table stu_offences OFF_DATETIME NOT NULL DATE DEMERIT_CODE NOT NULL NUMBER(2) MOD_DATETIME...

thanks

ok, I have it as follows but still get error.. == 46/43 PLS-00103: Encountered the symbol ";" when expecting one of the following: return Warning: Package Body created with compilation errors. ==== My code is as follows.. == create or replace package my_pkg...

how do I declare funciton inside a package? I'm having trouble declaring it inside a package.. == create or replace package my_pkg as procedure Check_Suspend ( p_stuID IN tableA.stuID%type); function Check_Limit ( p_stuID IN tableA.stuID%type); end my_pkg; create or replace package body...

I have a procedure Check_Suspend and it calls another procedure Check_Limit. Check_Limit procedure is basically just a select statement base on its 'IN parameter' to add the total of a field 'sum(a). How can Check_Suspend 1. call Check_Limit 2. get the value of sum(a) from Check_Limit?

query question for 3 tables... == Table Student Student_NO NOT NULL CHAR(10) NAME NOT NULL CHAR(30) STREET NOT NULL CHAR(20) POSTCODE NOT NULL CHAR(20) DOB...

what features does MTS (or other transaction monitor) provides that will enhance a typical 2 tier client-server system?

given, if I have a table as follows: create table test ( fieldA date not null, fieldB char (6) not null, fieldC char (30) not null, fieldD char (10) not null, constraint pk_test primary key (fieldA, fieldB)) How can I write a update procedure where the update statement is dynamic...

how can I do a delete with a CASCADE

I have 2 tables as follows Table A DATETIME NOT NULL DATE REG_NO NOT NULL CHAR(6) .... constraint pk_a primary key (reg_no, datetime), Table Audit DATETIME NOT NULL DATE REG_NO...

I am new to MS products and how it fits the overall picture in terms of architecture. 1. What does MTS do? 2. What is MTS relation with respect to .NET or what role does it plays? 3. In creating or "giving new life" to a old product, I have a old system which is essentially...

whenever I insert/update/delete an employee_salary table, I need to 1. write to an audit table , procedure write_audit 2. check whether salary has reached limit, procedure check_sal I have 2 procedures to handle point "1" and point "2". But how can I do a trigger that will...