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: We can get the MAX value of a sequence by using the data dictionary view 'USER_SEQUENCES' .i.e. SELECT MAX_VALUE FROM USER_SEQUENCES WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE' ...
How to skip columns while loading data with SQLLDR
Latest Answer: specify Filler Load datatruncate into table empfields treminated by'|'(field1,field2 filler,field 3) ...
What are analytical functions and how are they used?
Latest Answer: Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and is defined by the analytic_clause.for example:SQL> ...
How do you create nested tables?
How to create temporary table? Give some example
Latest Answer: create table temp as select*from base table where 1=1; ...
Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode
Latest Answer: I checked the code it's working fine. ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
