Home »
» HPMS - HR -MODULE -PROBLE-NEW CREATE DESIGNATION
4:38 PM
Related Posts:
For Loop :
Example :
In this example used a pakage pkg_mm.prcinsitemstk
<<Pakage>>
<<Procedure>>
PROCEDURE prc_insitemstk (
p_column_name IN VARCHAR2, &n… Read More- Procedure :
A procedure does not have a return type and should not return any value but it can have a return statement that simply stops its execution and returns to the caller. A procedure is used to return multiple values otherwise it… Read More
Trigger in oracle forms
All lINK :
1. http://www.123techguru.com/types-of-controls/
Built_in sub programs used in Form Triggers .
1 commit_form used to save changes ( Valid for DML )
2 clear_form clears all the blocks in form and place t… Read More- Sql Query:
Count duplicate value
1.
SELECT REG_NO, COUNT(REG_NO)
FROM OP_APPOINTMENT
WHERE APPOINT_DATE BETWEEN NVL(:P_DT1,APPOINT_DATE) AND NVL(:P_DT2,APPOINT_DATE)
GROUP BY REG_NO
HAVING ( COUNT(REG_NO) > 1 )
2.
select PO… Read More
- SQL:
## Used for show table name whose column name is user input :
SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE UPPER(COLUMN_NAME)='COLUMN_NAME'
Sub query :
select appoint_date,doc_name,doctor_no,doc… Read More
Time in Dhaka 
All lINK : 1. http://www.123techguru.com/types-of-controls/ Built_in sub programs used in Form Triggers . 1 commit_form used to ...
বয়স সবে ত্রিশের কোটা পেরোচ্ছে। আর এরই মধ্যে খেয়াল করলেন , মাথার চুল পড়ে যেন টাক হয়ে যাচ্ছে ! ব্যাপারটা মোটেই সুখকর ...
How to Connect Oracle Database with Microsoft Access Database? My first post for oracle developer. when you want to try c...
0 comments:
Post a Comment