 Related Questions In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display In PL/SQL I need to get like this scenario. if I am doing manipulation on a table, I need to display a record as Non-Updateable. It need to show a message to the user. How it is possible.Thanks in Advance. Read Answers (7) | Asked by : murthy How can we find the status (enabled/disable) of the trigger and the user who changed the status in SQL-Server.Many thanks. Read Answers (2) | Asked by : Shahid I want to convert source Date format "CCYYMMD" to "CCYY-MM-DD23.59.59.999999" in to the target for example source date is 19980224it should be in target 1998-02-24.23.59.59.999999 Read Answers (1) | Asked by : Sachin Latest Answer : use execute immediate to write DDL statements.but you should have create system previlege on the schema. ... Read Answers (1) | Asked by : vasudev Latest Answer : We can call a function from anonymous block as a part of sql statement written in that block.eg: create or replace function fn_emp(v_empno in number)return varchar2 isbeginselect ename into v_ename from empwhere empno=v_empno;return v_ename;end;this function ... Read Answers (2) | Asked by : Anuruddha SINGH Latest Answer : you can use SYSDATE oracle.lv_today := sysdate;or select sysdate into lv_today from dual;both the statements assign sysdate to lv_today ... How can I use the bind variable in a report to create an output file. For example I give the starting date and end date. I would like to get the report output in a file which has the start date and end date in it's name. View Question | Asked by : sk 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 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 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
