OilSheikh's Content - PHP Freaks

Urgent Help Needed > what's wrong with these codes

OilSheikh replied to OilSheikh's topic in PostgreSQL

2. Calculate average salary of all employees excl. the highest paid fat cat CREATE OR REPLACE FUNCTION average_emp RETURN AVGSAL IS BEGIN SELECT SAL FROM EMP2 WHERE EMPNO != NULL AND AVGSAL (NUMBER ) = AVG(SUM(SAL) - MAX(SAL)) ; DBMS_OUTPUT.PUT_LINE('Average Salary is : ' || AVGSAL);

Urgent Help Needed > what's wrong with these codes

OilSheikh posted a topic in PostgreSQL

Help would be much appreciated. 1. User prompted for values... values checked ... values entered into table. ACCEPT eno NUMBER - PROMPT "Enter Employee no :" ACCEPT enam VARCHAR2 - PROMPT "Enter Employee name :" ACCEPT jo VARCHAR2 - PROMPT "Enter Job Title :" ACCEPT man NUMBER - PROMPT "Enter Manager no :" ACCEPT hd DATE - PROMPT "Enter Starting Date :" ACCEPT sala NUMBER - PROMPT "Enter Employee's salary :" ACCEPT com NUMBER - PROMPT "Enter Employee commission :" ACCEPT dno NUMBER - PROMPT "Enter Employee's Department number :" EXECUTE add_any_emp ( 'eno','enam','jo','man','hd','sala','com','dno'); CREATE OR REPLACE PROCEDURE add_any_emp (aEMPNO IN NUMBER, aENAME IN VARCHAR2, aJOB IN VARCHAR2, aMGR IN NUMBER, aHIREDATE IN DATE, aSAL IN NUMBER, aCOMM IN NUMBER, aDEPTNO IN NUMBER ) AS BEGIN SELECT EMPNO FROM EMP2; IF EMP2.EMPNO = aEMPNO THEN raise_application_error(-20101, 'Employee exists'); ELSE IF aSAL > 20000 THEN aSAL = 20000 ELSE INSERT INTO EMP2 VALUES ( aEMPNO, aENAME, aJOB, aMGR, aHIREDATE, aSAL, aCOMM, aDEPTNO ); END IF; END IF; end;

[SOLVED] SQL* PLUS Oracle SQL DEVELOPER Help

OilSheikh replied to OilSheikh's topic in Other RDBMS and SQL dialects

Thanks. Sort of helped.

[SOLVED] SQL* PLUS Oracle SQL DEVELOPER Help

OilSheikh posted a topic in Other RDBMS and SQL dialects

It's been a long time sicne I cam here. Well, I finished my degree and went the tech support road rather than the Programming road for work. But, I m now back in uni and am once again doomed! I need some help with SQL. Help would be much appreciated. Please tell me on how to fix the incorrect code I have. 1. A script that asks for two hire dates and enables finding employees between them. ( Yes, I already have a table! ) Output required: EMPLOYEES HIRE DATE __________ ________ Empname, job date PROMPT Enter First Date ACCEPT a DATE PROMPT Enter Second Date ACCEPT b DATE SELECT ENAME, JOB, HIREDATE FROM EMP WHERE HIREDATE BETWEEN a AND b COLUMN ENAME HEADING Employees COLUMN ENAME FORMAT ENAME, JOB

Why doesn't these Lists show what I want to see

OilSheikh posted a topic in HTML Help

Here's the Code. I can't seem to find any errors! Even printed and checked - but can't find nothing. Help would be greatly appreciated. <html> <head> <title>Welcome to Glory Community Accounting services</title> </head> <body> <?php include("menu.php"); ?> <p><br /> <b> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> Services for Charity Organizations </font></b>  </p> <ul imagesrc="sqblue.gif"> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#0033CC"> <li>Financial Reporting</li><br />  <ul imagesrc="sqpink.gif"> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> <li>Budgeting and Forecasting</li> <li>CashFlow Statement</li> <li>Year End Accounts</li><br /> </font> </ul> <li>Payroll Processing</li><br /><br /> <li>Fixed Assets : <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> Maintenance & Processing to a Register </font> </li> </font> </ul> <p><br /><b> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> Services for Businesses </font></b>  </p> <ul imagesrc="sqblue.gif"> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#0033CC"> <li>Bookkeeping and Accounting Services</li><br />  <ul imagesrc="sqpink.gif"> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> <li>Day-to-day Bookkeeping service</li> <li>Year-end Accounts</li> <li>Independent Examiner's Report</li> <li>Quarterly Management accounts report</li> <li>Budget preparation & Business plan</li> <li>Financial and PAYE advice</li> <li>Professionally manage Source Documents</li> <li>Support new Organizations with Accountancy needs</li> <li>Advice on completing Funding applications</li> <br /> </font> </ul> <li>Payroll Services</li><br />  <ul imagesrc="sqpink.gif"> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> <li>Process Payrll on a Monthly/Weekly/Fortnightly basis</li> <li>Provide Payslips</li> <li>Submit Year-End Returns (P35/P14 & P60)</li> <li>Deal with PAYE queries</li> <li>Taking responsibility for Inland Revenue inspections</li> <br /> </font> </ul> <li>Other Services</li><br />  <ul imagesrc="sqpink.gif"> <font face="Lucida Sans Unicode" style="font-size: 11pt" color="#808080"> <li>Bookkeeping consultation available at client's premises</li> <li>Volunteer scheme available for Accounting Students</li> <li>Employment and Training for Accounting students</li> <li>Training on Computerized Accounts and Book keeping</li> <br /> </font> </ul> </font> </ul> </body> </html>

Sign In

Profiles

Forums

Everything posted by OilSheikh

Important Information