ORA-00933: SQL command not properly ended

I am giving sql command while getting the error ORA-00933 sql command not properly ended,

my command is :

UPDATE BLOCKIPCONFIG SET ALLOWBLANKUSERID='Y', BLOCKMQMUSERS='Y', USERIDUPPERLOWERCASE='Y', MAXCHANNEL=5, ALLOWSELFSIGNEDCERT='Y', SYSLOG='Both', SYSLOGFACLITY='Log_User', SYSLOGPRTY='Log_ERR', TERM='N', LOGCOUNT=22, LOGCYCLE='Y', LOGEXT='Log', LOGFILENAME='BLOCKIP', LOGDIRECTORY='aaa', LOGFORMAT='NDC', MAXLOGSIZE=1024, LASTMODIFIEDBY='shaan', LASTMODIFIEDON=23-OCT-09 10.47.0000000000, WHERE ID=106;

what is the problem in this... i am so thankful if u reply me nd resolve my problem.

SELECT rrm.id as  + RESOURCE_ID , rrm.action || '/' || rrm.sub_action || '/' || rrm.method || Decode(rrm.condition_param,NULL,NULL,'?'||rrm.condition_param) AS  + RESOURCE_STRING , rrm.role_bit_sum as  RESOURCE_ACCESS , rd.description as RESOURCE_DESCRIPTION FROM resource_role_mapping rrm, resource_description rd where rrm.description_id=rd.id ORDER BY RESOURCE_STRING;

SELECT DISTINCT u.USERID as USERID FROM USERS u, USERAPPLICATION ua WHERE u.USERID = ua.USERID AND ua.APPID LIKE ? AND BITAND(ua.ROLE_BIT_SUM,?) > 0 order by USERID;

SELECT name from channeldefinition where queuemgrname=(select queuemanagername from queuemanager where intanceid='PROD') , channeltype='serverconnection' , servername='dum.web.mq.sena';

SELECT name from channeldefinition where queuemgrname=(select queuemanagername from queuemanager where instanceid='DEV')AND channeltype='SERVERCONNECTION CHANNEL' AND servername='dum.web.mq.sena';

I am new in oracle query. when i run the query below. it returns following error:

Connected.
SELECT * FROM   SBI_ED.Service_Type, SBI_ED.CCS_Assignment_Matrix AS TTID_471L16494R7317 WHERE TTID_471L16494R7317.Current_Level  LIKE 'RO'; AND (SBI_ED.Service_Request.Service_Type = Service_Type.Service_Type_Id) AND (TTID_471L16494R7317.Service_Type = Service_Type.Service_Type_Id)
                                                                  *
ERROR at line 1:
ORA-00933: SQL command not properly ended

Query:

Connect system/cdccrm_123@orcl
SELECT * FROM   SBI_ED.Service_Type, SBI_ED.CCS_Assignment_Matrix AS TTID_471L16494R7317 WHERE TTID_471L16494R7317.Current_Level  LIKE 'RO' AND (SBI_ED.Service_Request.Service_Type = Service_Type.Service_Type_Id) AND (TTID_471L16494R7317.Service_Type = Service_Type.Service_Type_Id);

I am trying to join 4 tables, but its not working could anyone shed some light. Thanks

SELECT Attends.TechENo, Attends.ProjectTime, Attends.ProjectDates,  (SELECT Technical_Engineer.TechName, Project.ProjectName, Company.CompanyName, Company.PM_SSNo, ProjectStaff.StaffName
FROM all_tables tbls)
FROM Attends
WHERE Attends.ProjectID=Project.ProjectID
ON Technical_Engineer.TechENo=Attends.TechENo;

ON Technical_Engineer.TechENo=Attends.TechENo

*

ERROR at line 5:


ORA-00933: SQL command not properly ended

i just wrote the above message but its ok i have sorted it out

thanks :)

Hi, i´m new in Orace and i´m trying to do the update bellow:

UPDATE SEG_COB
SET    SC.DT_FIM    = SG.DT_FIM
FROM   SEG_COB         SC,
      SEGDO_GRP_PLN    SG
WHERE  SC.NUM_CONT IN (44196113)
AND    SC.DT_FIM IS NULL
AND    SC.CD_MAT_ASS    = SG.CD_MAT_ASS
AND    SC.NM_SEQ_ASS     = SG.NM_SEQ_ASS
AND    SC.NM_SEQ_SEG     = SG.NM_SEQ_SEG
AND    SC.NM_SEQ_PLA    = SG.NM_SEQ_PLA
AND    SC.NM_CON         = SG.NM_CON
AND    SC.NM_PLA_VID    = SG.NM_PLA_VID

select *
from customer
where c_birthdate = '1970-01-01' > '1979-12-31';

I have two inline queries that checks for the number o f males and females from each dept and displays the information in  3 columns i.e dept, Male, Female. The two inline queries are working the information is grouped as required but the outer query that joins the two inline queries is not working out to display the information as required. Below is my query. Thanks

SELECT d.deptName, m AS "Male", f AS "Female"
FROM Dept d,
 (SELECT deptName, COUNT(Sex)
  FROM Staff
  WHERE Sex = 'M'
  GROUP BY deptName) m,

  (SELECT deptName, COUNT(Sex)
   FROM Staff
   WHERE Sex = 'F'
                 GROUP BY deptName) f,  
WHERE d.deptName = m.deptName;

cannot get this procedure created

set serveroutput on
CREATE OR REPLACE PROCEDURE Get_Item_Info
(
  accept p_inv_id prompt 'Enter Inventory ID #: '
  accept p_QTY_to_purch prompt 'Enter quantity to purchase: '
  )
declare
  v_inv_id number;
  v_QTY_to_purch number;
  v_item_desc varchar2;
  v_inv_price number;
begin
  v_inv_id:=&p_inv_id;
  v_QTY_to_purch:=&p_QTY_to_purch;
  v_item_desc:=item_desc%rowtype;
  v_inv_price:= v_QTY_to_purch * v_inv_price;
  DBMS_OUTPUT.PUT_LINE('Enter Inventory ID: '||v_inv_id);
  DBMS_OUTPUT.PUT_LINE('Enter quantity to purchase: '||v_QTY_to_purch);
  DBMS_OUTPUT.PUT_LINE(v_QTY_to_purch||' units of Inventory ID: '||v_inv_id||','
  ||v_item_desc ||','||' will be ordered');
end;

Enter your messageUPDATE STAFF
SET S_CUR_SALARY = S_CUR_SALARY*1.05
FROM WORK_EXPERIENCE
WHERE STAFF.STAFF_NO=WORK_EXPERIENCE.STAFF_NO
AND WORK_EXPERIENCE.E_FINISH_DATE

Error starting at line 1 in command:
UPDATE STAFF
SET S_CUR_SALARY = S_CUR_SALARY*1.05
FROM WORK_EXPERIENCE
WHERE STAFF.STAFF_NO=WORK_EXPERIENCE.STAFF_NO
AND WORK_EXPERIENCE.E_FINISH_DATE
Error at Command Line:2 Column:36
Error report:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:   
*Action:

Enter your message I tried the above correction and now I get a relational error. Any ideas how to correct? thanks.

Error starting at line 1 in command:
UPDATE STAFF
SET S_CUR_SALARY = (select S_CUR_SALARY*1.05
FROM
WORK_EXPERIENCE
WHERE STAFF.STAFF_NO=WORK_EXPERIENCE.STAFF_NO
AND
WORK_EXPERIENCE.E_FINISH_DATE)
Error at Command Line:7 Column:29
Error report:
SQL Error: ORA-00920: invalid relational operator
00920. 00000 -  "invalid relational operator"
*Cause:   
*Action:

I'm new to sql and am trying to display the most recent employment start date (currently I'm getting all of them).  sql is being used in conjuction w/intelliview.

SELECT UNIQUE
  L.CUST_NUMBER AS ACCT_NUMBER, L.CUR_BALANCE AS CUR_BAL, L.APR, T.TAG_LABEL, (CASE
    WHEN L.R78_CONTR = 'R' THEN 'R'
    WHEN L.R78_CONTR = 'P' THEN 'P'
    ELSE 'S'
  END) AS CONTRACT_TYPE, C1.CUST_LNAME AS BYR_LAST_NAME, C1.CUST_FNAME AS BYR_FIRST_NAME, C2.CAR_YEAR, C2.CAR_MAKE, C2.CAR_MODEL, C1.CUST_STATE AS BYR_RES_ST, C2.CAR_VIN, C1.CUST_SSN AS BYR_SSN, C1.CUST_DOB AS BYR_DOB, C.CUST_LNAME AS COBYR_LAST_NAME, C.CUST_FNAME AS COBYR_FIRST_NAME, C.CUST_SSN AS COBYR_SSN, C.CUST_DOB AS COBYR_DOB, C.CUST_STATE AS COBYR_RES_ST, C1.CUST_ADDR1 AS BYR_STREET, C1.CUST_APT_NO AS BYR_APT#, C1.CUST_CITY AS BYR_CITY, C1.CUST_ZIP AS BYR_ZIP, C1.CUST_ADDR2 AS BYR_ALT_STREET, C1.CUST_CITY2 AS BYR_ALT_CITY, C1.CUST_STATE2 AS BYR_ALT_ST, C1.CUST_ZIP2 AS BYR_ALT_ZIP, C1.CUST_PHONE AS BYR_HM_PHN, C1.CUST_PHONE2 AS BYR_HM_PHN_2, C1.CUST_PAGER AS BYR_PGR_OR_CELL_2, C1.CUST_CELL AS BYR_CELL, C.CUST_ADDR1 AS COBYR_STREET, C.CUST_APT_NO AS COBYR_APT#, C.CUST_CITY AS COBYR_CITY, C.CUST_ZIP AS COBYR_ZIP, C.CUST_ADDR2 AS COBYR_ALT_STREET, C.CUST_CITY2 AS COBYR_ALT_CITY, C.CUST_STATE2 AS COBYR_ALT_ST, C.CUST_ZIP2 AS COBYR_ALT_ZIP, C.CUST_PHONE AS COBYR_HM_PHN, C.CUST_PHONE2 AS COBYR_HM_PHN_2, C.CUST_PAGER AS COBYR_PGR_OR_CELL_2, C.CUST_CELL AS COBYR_CELL, E.START_DATE AS BYR_START_DATE, E.EMPLOYER AS BYR_POE_NAME, E.ADDRESS AS BYR_POE_STREET, E.CITY AS BYR_POE_CITY, E.STATE AS BYR_POE_ST, E.ZIP AS BYR_POE_ZIP, E.PHONE AS BYR_POE_PHN#, E.EXT AS BYR_POE_EXT, E.CONTACT AS BYR_POE_SUPERVISOR, E.OCCUPATION AS BYR_POE_OCCUPATION, E.PAY_PERIOD AS BYR_POE_PAY_CYCLE, E.WORKSHIFT AS BYR_POE_SHIFT, E.DEPARTMENT AS BYR_POE_DEPT, E1.START_DATE AS COBYR_START_DATE, E1.EMPLOYER AS COBYR_POE_NAME, E1.ADDRESS AS COBYR_POE_STREET, E1.CITY AS COBYR_POE_CITY, E1.STATE AS COBYR_POE_ST, E1.ZIP AS COBYR_POE_ZIP, E1.PHONE AS COBYR_POE_PHN#, E1.EXT AS COBYR_POE_EXT, E1.CONTACT AS COBYR_POE_SUPERVISOR, E1.OCCUPATION AS COBYR_POE_OCCUPATION, E1.PAY_PERIOD AS COBYR_POE_PAY_CYCLE, E1.WORKSHIFT AS COBYR_POE_SHIFT, E1.DEPARTMENT AS COBYR_POE_DEPT, L.CHARGE_OFF_DATE, L.LOC_SALE AS DEALER, C2.AUCTION_AMT, C3.AMT_TENDERED AS LAST_TRANS_AMT, L.LAST_INTR_DATE AS LAST_TRANS_DATE, T.TAG_DATE AS TAG_DATE, C3.TRANS_CODE
FROM
  AMSUSER.LOAN L
  LEFT OUTER JOIN AMSUSER.TAGFILE T ON L.CUST_NUMBER = T.CUST_NUMBER
  INNER JOIN AMSUSER.CUSTOMER C1 ON L.CUST_NUMBER = C1.CUST_NUMBER
  INNER JOIN AMSUSER.CAR C2 ON L.CUST_NUMBER = C2.CUST_NUMBER
  LEFT OUTER JOIN AMSUSER.REPO R ON L.CUST_NUMBER = R.CUST_NUMBER
  LEFT OUTER JOIN AMSUSER.LOAN L3 ON L.CUST_NUMBER = L3.CUST_NUMBER
  LEFT OUTER JOIN AMSUSER.CUSTOMER C ON L3.COBUYER1_CUST_NUMBER = C.CUST_NUMBER
  FULL OUTER JOIN AMSUSER.EMPLYMNT E ON L.CUST_NUMBER = E.CUST_NUMBER
  FULL OUTER JOIN AMSUSER.EMPLYMNT E1 ON L3.COBUYER1_CUST_NUMBER = E1.CUST_NUMBER
  LEFT OUTER JOIN AMSUSER.CUSTHIST C3 ON L.CUST_NUMBER = C3.CUST_NUMBER
WHERE L.LOAN_TYPE <> 'IS' AND
      T.TAG_LABEL IN ( 'IMPD', 'INDB', 'IR', 'NCOL', 'RVOL') AND
      C3.TRANS_CODE IN ( 'MS', 'NF', 'RG') AND
      L.LAST_INTR_DATE = C3.INTR_DATE AND
      C3.AMT_TENDERED > 0