|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions How can I write a function which returns previous business date of given input date1. skip holidays when you find previous day2. skip Sunday and saturday's when you find previous dayUS holidays are Latest Answer : if you need to get the previous business date, just change the in_dt variable in declaration to input_dt date := '&Dt';in_dt date := input_dt - 1; ... Read Answers (2) | Asked by : Rajesh For each hour, list the number of called, total transactions' values, and total duration?if you have these tables:1- 'calls'columns: called_number, Customer_ID, call_date, call_time_started, User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate 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) ... 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
