ranadhee_85

 Profile Answers by ranadhee_85 Questions by ranadhee_85

• Feb 9th, 2011

SELECT sysdate FROM dual;

younaskhan40

 Profile Answers by younaskhan40 Questions by younaskhan40

• Apr 20th, 2010

Select To_Char(SYSDATE,'DD-MON-RRRR HH:MI:SS AM') From Dual;

Answer Question  Select Best Answer

 To  pass  one  or  more  parameters to a called form, the calling form must perform  the  following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically.     Create  a  parameter  list  to  execute  the  add  parameter  built-in procedure...

Shital Mistry

• Aug 11th, 2012

Calling form must first create parameters under the parameter node.

younaskhan40

 Profile Answers by younaskhan40 Questions by younaskhan40

• Apr 16th, 2010

Create parameter list.Add required parameters  with add_parameter(receiving_parameter_name, field type, sending_parameter_name)Now pass this into call_form or open_form built_in procedure.

Answer Question  Select Best Answer

Debarghya

• Aug 29th, 2017

C. Character

Code
GO_BLOCK(block name);
FIRST_RECORD;
LOOP
...............
       EXIT WHEN :SYSTEM.last_record = TRUE ;
       NEXT_RECORD;
END LOOP;

sunil

• Jul 20th, 2015

"Boolean" value is recorded

Answer Question  Select Best Answer

 Post writes  data in the form to the database but does not perform database commitCommit permanently writes data in the form to the database.

younaskhan40

 Profile Answers by younaskhan40 Questions by younaskhan40

• Apr 20th, 2010

POST will temporary save data in the relevant table.If you do not use commit after post then the temporary saved data will be lost.COMMIT permanently Save Data in the table

Answer Question  Select Best Answer

 PRE-QUERY fires once.   POST-QUERY fires 10 times.

younaskhan40

 Profile Answers by younaskhan40 Questions by younaskhan40

• Apr 20th, 2010

PRE-QUERY fire once when block goes in execute-query Mode.andPOST-QUERY  fire=TOTAL NUMBER OF RECORDS RETRIEVED.in the above case POST-QUERY fires 10 times.

AShutosh Trivedi

• Jun 10th, 2006

Pre_Query fires onceAnd Post_Query fires for each record means in this condition it fires 10 times.    

Answer Question  Select Best Answer