What steps should a programmer should follow for better tunning of the PL/SQL blocks?
How do we do mass updates in Oracle PL SQL?
Latest Answer: use package for mass update. ...
Outline the List of PRAGMA'S used in Oracle.
Latest Answer: Inputting the date in PL/SQL is same as in SQL. Simply pass the date as a string in the format DD-MON-YYYY.Eg: SELECT * FROM TABLE WHERE HIRE_DATE='dd-mon-yyyy'.OrYou can also use Date functions TO_DATE('25-aug-2008','......date formate......');Hope this ...
How can i choose which query is best?i.e On which factors i can choose the best query?
Latest Answer: By forcing the SQL engine to use indexes.If query is too much nested then break it into two or three queries using temp tables and then write one query by joining these temp table to perform the task. ...
How can i schedule a procedure every day at 10 pm
Latest Answer: This is the sample code you have to adjust time according to your requirementSET AUTOPRINT ONVAR jobno NUMBER;BEGIN DBMS_JOB.SUBMIT(:jobno, 'JOBNAME;', TRUNC(SYSDATE) + 6/24, 'TRUNC(SYSDATE + 1) + 6.183/24'); COMMIT;END; ThanksRajiv
GuptaYogik Technologies ...
Latest Answer: Package have more advantages ModularityEasily Application designBetter PerformenceInformation Hiding ...
How to set time in pl/sql(Toad) JOB
How many columns you can create in table from this type "long raw"?
Latest Answer: We can use only one long column in a table ...
How to find the max value in a Sequence?
Latest Answer: If you don't own the sequence, you may look at all_sequences, which shows sequences in other schemas that you have access to:select max_valuefrom sys.all_sequenceswhere sequence_owner = '&sequence_owner' and sequence_name = '&sequence_name' ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
