Replace Function In Sql

Trim :- Removes leading and /or trailing blanks(or other characters ) from a string.Syntax:- TRim([[<trim_spec >] char ]SQL> select trim(' Aptech Computer') from dual;Returns the following result.TRIM('APTECHCOM---------------Aptech ComputerConcate Function:--The syntax for the oracle concat function is :concat(string1,string2)Parameters...

Read More

ORA-01033: ORACLE initialization or shutdown in progress

When you login into Oracle Database and it throws following error message: i could not login into my account . I was unable to login with the following error. But datbase was in open state.If your database shutdown is in progress then wait for some time until the database is shutdown and start your database with Startup command.ORA-01033: ORACLE initialization...

Read More

How can U call Pl Sql Procedure From Sql

You can type  execute procedure (short term EXEC) like EXEC procedure_name; -- Write a Plsql procedure that accept employee_id from user and print his/her salary  . CREATE OR REPLACE PROCEDURE SALPRO(P_ID IN NUMBER) IS   V_SAL NUMBER; BEGIN   SELECT SALARY INTO V_SAL FROM EMPLOYEES WHERE EMPLOYEE_ID=P_ID;   DBMS_OUTPUT.PUT_LINE('The...

Read More

Boolean Exceptions In PLSQL

declare    v_foundrows boolean := false; (adsbygoogle = window.adsbygoogle || []).push({}); begin    for r in ( select * from emp where employee_id= &dno )    loop       dbms_output.put_line(r.last_name || ' ' || r.salary);       v_foundrows := true;    end loop;  ...

Read More