asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

Yes we can, in WHEN-NEW-RECORD-INSTANCE Trigger.

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

Dynamic Reports are the Reports which is based on the GLOBAL_TEMPORARY TABLE. can be used in BEFORE RUN REPORT Trigger to populate the Data into that table by calling function/procedure. After report ...

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

Declare the PRAGMA AUTONOMUS_TRANSACTION; in Procedure,Package,Function/Anonymous Block etc.

Answer Question  Select Best Answer

VIKASH KUMAR

• Mar 12th, 2013

Use I/O package .

Answer Question  Select Best Answer

How to get number in words we are using Oracle 10g software and in reports, i am trying to give as function code and return value as placeholder, but i am getting an error as foll.REP:1401 'cf_1formula': Fatal PL/SQL error occurred.Thanks in advanceKrishnan R

Ashish

• Mar 10th, 2014

"vb Function No_To_Word(Amount Number) Return Varchar2 Is Wordsamt Number(30, 12) := 0; Words Varchar2(500) := ; Str Varchar2(50) := ; Amt Number(30, 1...

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

"sql Set Serveroutput On 1000000 Declare V_Input NUMBER := &TESTED; Function Numbertowords(P_Number In Out Number) Return Varchar2 Is V_Words Varchar2(32767) := ; V_Te...

Answer Question  Select Best Answer

K.MOHANRAJ

• Jan 24th, 2015

YES, USING WEBUTIL

Answer Question  Select Best Answer

Azhar Hussain

• Apr 28th, 2015

Yes it is possible indirectly,
On Pre-INSERT OR PRE-UPDATE assign to related database column

paddu_24

 Profile Answers by paddu_24 Questions by paddu_24

• Oct 27th, 2008

No its not possible

Answer Question  Select Best Answer

What are static and dynamic reports in oracle and where do we use them?

kamaraj

• Jul 13th, 2015

Static reports query is known in design time
Dynamic reports query is known during run time only

Answer Question  Select Best Answer

 Form   Menu   Library

sunil

• Jul 20th, 2015

Types of modules are:
Menu module
PL/SQL Libraries
Object Library

nishajan09

 Profile Answers by nishajan09 Questions by nishajan09

• Aug 11th, 2008

Form moduleMenu modulePl/SQL Library module Object Library module

Answer Question  Select Best Answer

Lily

• Jul 6th, 2017

False

SWETA RANI

• Aug 3rd, 2016

False .
SYSTEM.EFFECTIVE_DATE Represents the effective database date. The variable value must always be in the following format DD-MON-YYYY HH24:MI:SS

Answer Question  Select Best Answer

deepak

• Jul 15th, 2017

I just use this code
but it is showing error - no list element defined for list item

deepak

• Jul 15th, 2017

Will you provide me the code for populating list
as I am sending to you my parameter
record group= country_name
item=:country.c_name
there is block name= table name and item name = column name

Answer Question  Select Best Answer

Mohammad

• Aug 16th, 2017

No, a canvas can have only one window at a time

VAZEER

• Aug 5th, 2011

No

Answer Question  Select Best Answer

Debarghya

• Aug 29th, 2017

C. Character

Code
 

sunil

• Jul 20th, 2015

"Boolean" value is recorded

Answer Question  Select Best Answer