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...

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...

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...

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...

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...

How can I insert the system date time into a table?

I have a table as follows: SQL> desc employee; Name Null? Type ----------------------------------------- -------- ---------- EMP_NO NOT NULL NUMBER(4) EMP_NAME NOT NULL CHAR(20)...

I have a table driver as follows Name Null? Type ----------------------------------------- -------- ------------- DRV_LIC_NO NOT NULL CHAR(10) DRV_NAME NOT NULL CHAR(30) DRV_STREET...

CREATE OR REPLACE PACKAGE employee_pkg AS PROCEDURE New_Employee ( p_empname IN employee.emp_name%type, p_salary IN employee.emp_salary%type, p_sdate IN employee.emp_sdate%type, p_deptno IN department.dept_no%type); PROCEDURE Del_Employee ( p_empname IN employee.emp_name%type); END...

I have 2 tables employee and department. In department, there is a field dept_count which keeps track of the number of employees in a certain department. Every time a new employee is added, there is a sequence that can auto_increment eg. employeeNo.NextVal Question is 1. Is there a way to...

I have created a set of tables using a user called PADMIN and is now writing a PL/SQL package that have various logic for different scenarios. How can I create the package such that any logged in user will be able to carry out the tasks BUT direct entry via SQL for such users (other than...

Given following tables, how can I get the customers who have made an order with overall value of 500.00 in the last 30 days. === customer Name Null? Type constraints ------------------------------- -------- -------- ------------ CUSTNUMB...

just to generate some discussions.... - no flames please... healthy discussion only