Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
1 11808how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
2124Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
3 5158There is no strict data types in perl unlike in other high level languages like Java so wouldn't that be a problem if a code in perl is to be a written by a big team of 20+ members ?"
2413Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
4 6160i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
L&T,
2506i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
L&T,
5 10176i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
3 6266i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
GSK,
1 5599i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
L&T,
3 7440i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?
GSK,
6 10535
Can we install Oracle database in VT100 Server?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
How to connect to a remote database using Applet?
How database connectivity in XML is achieved?
How data can be inserted into long row column of database?
How to know howmuch data is truncated?
What are the parameters available in user exit for enhancing master data?
What are the data target administration tasks?
Where the data is extracted during init of delta and during delta updates?
How do you transform OH data?
How will you do data driven testing using Robot?
Where the datapool values are stored?
What is datapool cursor?
What is standard data type and what is user defined data type?
What information is contained in the Datapool_config section?