Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Convert number of seconds to Hours:Minutes:Seconds format
Hi, SELECT TO_CHAR(SYSDATE,'SSSSS') FROM DUAL; -- will return like 54071SELECT TO_CHAR(TO_DATE(54071,'SSSSS'),'HH24:MI:SS') FROM DUAL;-- will RETURN like 15:01:11 It will help
Hi,
SELECT TO_CHAR(SYSDATE,’SSSSS’) FROM DUAL; — will return like 54071
SELECT TO_CHAR(TO_DATE(54071,’SSSSS’),’HH24:MI:SS’) FROM DUAL;– will RETURN like 15:01:11
It will help
See lessWhat is the difference between schema and user ?
User is a credential to log-into to the database.Schema is group of objects of databse to be used for same purpose.One schema cam have multiple users to log into
User is a credential to log-into to the database.
Schema is group of objects of databse to be used for same purpose.
One schema cam have multiple users to log into
See lessget number of days between two dates column in oracle sql?
Hi, Like this we can use: SELECT pol_fm_dt, pol_to_dt, ROUND(pol_to_dt - pol_fm_dt) FROM pgit_policy;
Hi, Like this we can use:
See lessHow to execute multiple procedures simultaneously ?
Hi, Its better you can create different jobs for each procedure and setting their time same to start execution.
Hi,
Its better you can create different jobs for each procedure and setting their time same to start execution.
See lessHow to use COMMIT or ROLLBACK inside database trigger ?
Hi, You can creater a procedure to insert into your test_table_log table with parameter of the columns of thie table. Then on your test_table table trigger call this procedure by passing the values. Commit will be in your calling procedure. So it will work.
Hi,
You can creater a procedure to insert into your test_table_log table with parameter of the columns of thie table.
Then on your test_table table trigger call this procedure by passing the values.
Commit will be in your calling procedure. So it will work.
See lessReturn more than one row from stored procedure in pl/sql
CREATE OR REPLACE PROCEDURE pr_return_multiple_out(p_row_number VARCHAR2) IS CURSOR c0 IS SELECT pol_no, pol_assr_name FROM pgit_policy WHERE ROWNUM <= p_row_number; BEGIN FOR i IN c0 LOOP dbms_output.put_line(i.pol_no||' : '||i.pol_assr_name); END LOOP; EXCEPTION WHEN OTHERS THEN dbms_output.putRead more
CREATE OR REPLACE PROCEDURE pr_return_multiple_out(p_row_number VARCHAR2) IS
CURSOR c0 IS
SELECT pol_no, pol_assr_name FROM pgit_policy WHERE ROWNUM <= p_row_number;
BEGIN
FOR i IN c0 LOOP
dbms_output.put_line(i.pol_no||’ : ‘||i.pol_assr_name);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(SQLERRM);
END pr_return_multiple_out;
/
—————-Calling by passing number of output we want
BEGIN
See lesspr_return_multiple_out(4);
END;
/