Recent content by slok

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?