plsql

[Solved] PL/SQL Triggers -firing question3

by

Try this…. for trigger CREATE TRIGGER insert_book ON [dbo].[Books] FOR INSERT AS insert into books (id_book,title) values(12,’book12′); PRINT ‘Insert Book’ GO 6 solved PL/SQL Triggers -firing question3

[Solved] ORA-06550: line 13, column 4: PLS-00103: Encountered the “UPDATE” ORA-06550: line 15, column 3: PLS-00103: Encountered the symbol “END”

by

EXIT WHEN FLAG=1/*give some exit criteria here .You wrote update statement which was incorrect*/; –update table set counter=1 where counter is NULL; — LOOP until condition is met END LOOP; 0 solved ORA-06550: line 13, column 4: PLS-00103: Encountered the “UPDATE” ORA-06550: line 15, column 3: PLS-00103: Encountered the symbol “END”

[Solved] Sql code to create the Mirror image of the string in Oracle sql [closed]

by

If “mirror” is reversed text use: SELECT REVERSE(‘my_text’) FROM dual; EDIT: SqlFiddleDemo SELECT t ,REVERSE(t) AS Mirror1 ,TRANSLATE(t, ‘abcdefghijklmnopqrstuvwxyz’,N’ɐqɔpǝɟbɥıظʞןɯuodbɹsʇnʌʍxʎz’) AS Mirror2 ,TRANSLATE(REVERSE(t), ‘abcdefghijklmnopqrstuvwxyz’,N’ɐqɔpǝɟbɥıظʞןɯuodbɹsʇnʌʍxʎz’) AS Mirror3 FROM tab; 2 solved Sql code to create the Mirror image of the string in Oracle sql [closed]

[Solved] can you explain trim and what is doing? [closed]

by

In simple terms, trim removes whitespace from the beginning or end of a bit of text. For instance, it will turn ‘myvalue ‘ into ‘myvalue’ and ‘ tonsofexteriorwhitespace ‘ into ‘tonsofexteriorwhitespace’. Note that it won’t remove whitespace from the interior of the text though, so ‘ interior spaces remain ‘ becomes ‘interior spaces remain’. It … Read more

[Solved] ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]

by

It is very clear that you are not creating a dynamic query properly. Space is missing between TABLE’|| C.table_name It must be something like this: EXECUTE IMMEDIATE ‘TRUNCATE TABLE ‘|| C.table_name; — see space after TABLE Cheers!! 3 solved ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT … Read more

[Solved] VALUE NOT EXIST (SQL)

by

You can use exceptions. Try this: DECLARE y NUMBER; b emp.ename%TYPE; BEGIN y := :enter_no; SELECT ename INTO b FROM emp WHERE empno = y; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE(b); END; 0 solved VALUE NOT EXIST (SQL)

[Solved] My PL/SQL code is not working:

by

CREATE OR REPLACE PROCEDURE log(repname in varchar2) AS PACKAGE_NAME VARCHAR2,– give size here like varchar2(50) START_TIME DATE, END_TIME DATE, STATUS; BEGIN SELECT PACKAGE_NAME , PRCS_START_TIME , PRCS_END_TIME, STATUS — add into clause to assign selected –values in variables FROM CONTCL_OWNER.PROCESSLOG WHERE PACKAGE_NAME LIKE ‘%REPNAME%’ And ROW_NUMBER <=7 ORDER BY PRCS_START_TIME ; END; solved My PL/SQL … Read more

[Solved] Can we call a private procedure of a package from another package and can we call database procedure from a private package

by

If by private, you mean a procedure that’s defined in the package body and not exposed in header, then no. The other package won’t be able to “see” the procedure. SQL> CREATE OR REPLACE PACKAGE foo AS END; — No “public” procedures/functions 2 / Package FOO compiled SQL> CREATE OR REPLACE PACKAGE BODY foo 2 … Read more

[Solved] PLSQL: ORA-00933 why is INTO not working? [closed]

by

The INTO goes just after the SELECT part, before the FROM. select e.editionid into tagnow from webtags w, edition e Also, try to learn standard ANSI JOIN, instead of using this old Oracle way, and pay attention in using aliases in joiur join conditions. You query would become: SELECT e.editionid INTO tagnow FROM webtags w … Read more