Search results for query: *

Hello everyone, I am sorry but I have another problem with dbms_sql. I have the following program: DECLARE stmt INTEGER; BEGIN -- --Read in user values v_start_dt := '&START'; v_end_dt := '&END'; stmt := dbms_sql.open_cursor; dbms_sql.parse(stmt...

Hello everyone, I have the following sql script below using execute immediate: PROMPT Please enter in parameters when prompted... PROMPT start_dt PROMPT end_dt PROMPT DECLARE v_start_dt DATE; v_end_dt DATE; BEGIN -- --Read parameters v_start_dt := '&START_DT'...

Hello, I have the following select insert into statement: insert into student select student_id, student_cd, student_name from student where student_id = '9999' The two columns - student_id and student_cd are primary keys. When I try to insert, it gives me a 'unique constraint...

Hello, I have problems querying through a web application system when a name has a single quote in it (e.g. O'Brien). Can you please show me how I can change this select so that the single quotes get replaced with double quotes? I've tried the REPLACE and the ESCAPE function but it does not...

Hello, I have the following if statement with several layers of nesting. Everything seems to work fine except for the last elseif. Am I missing something, possibly an end if somewhere? IF (INSERTING OR :old.status_flag = 'INACTIVE') AND (:new.status_flag = 'ACTIVE') THEN INSERT INTO...

Can you please tell me if I am using decode correctly in this update statement? I am trying to compare a new and an old value in a trigger code and if the old value is not null and the new value is null, I would like for the value inserted into the table to be blank and not the value 'NULL'...