-
What is the command to interact with the Operating System ?
J.Sreedharan
- Aug 21st, 2007
You can use host command in 9i/10g which will interact with the Application server's OS. If you want to access the client machine OS then you have to use WEBUTIL functionality
kameshakundy
- May 31st, 2007
HOST command works fine with Oracle Developer 6i.Since Oracle Developer 9i and 10g are Web-enabled this became obsolete. In replacement of this, you need to install a utility called "Oracle WebUtil". ...
-
-
-
Is it possible to call a report from another report using report builder
ttparavindh
- Dec 14th, 2007
When we creating drill down report, we would use this following parameterSRW.RUN_REPORT.
-
What is lexical parameter in report? Explain benefits and usage of lexical parameter?
jagadeesh9
- Feb 22nd, 2008
Lexical P.M is used to pass string& is there it is Lexical P.M.we can use in FROM clausewe can't use in PL/SQL
devenar
- Nov 19th, 2007
You can create a lexical parameter(references) by entering an ampersand (&) followed immediately by the column or parameter name.Lexical parameter are placeholders for text that you embed in a SEL...
-
How we will find duplicate record in detail block when we leave the field
madhav_menti
- Apr 4th, 2008
In this senario?Better to ?use record group. Using record group we dump the table data at client system level and check the entered data. To achive this you write functions to find dup record under ...
osden
- Oct 7th, 2007
Create a trigger at form level When-database-trigger Post; (this
command will temporary apply the changes to the database) Than you find by Sql
Query if it is duplicate Record. -
Form 6i Forms Status
What are the forms status in form 6i
-
How are text files read and written in forms ?
dmdevaraj
- Apr 29th, 2008
To writeDeclareT_filename Text_Io.File_Type;w_NewLine varchar2(200); BeginT_filename := Text_Io.Fopen('c:test.txt', 'W');Text_Io.Put_Line(T_filename,'this is test...
kameshakundy
- Jun 22nd, 2006
The CLIENT_IO is just a replacement for TEXT_IO since the client-server mechanism is becoming obselete
-
Oracle Forms - Read Data and compare with sysdate
I want to retrieve data from table where apply date field from table which likedate = sysdate,so i not got a data , what i doe.g.select date from abc where date = sysdate;this is right or wrong ,plz give ans
prasant0661
- May 16th, 2008
Select app_date from application where app_date=sysdate;The above query is right but may not fetch record.sysdate defult format is = 'dd/mm/yyyy hh:mi:ss'app_date might format may be = 'dd/mm/yyyy'so please writeselect app_date from applicationwhere trunc(app_date)=trunc(sysdate)
-
How to print logo on the report by changing the Mode to Bitmap
rakeskul
- Jun 13th, 2008
There are two mathod 1 Click on insert and select the file link and put the path of logo2 Click on insert and use image and select logo for this no path is requiry
-
-
How i will run a report in scheduled task
I want to run a report daily, actually there is a whole data retrieving in one report so, i want the report daily at evening auto run and generate data and convert it into pdf, so how i it put the report in scheduled task?
Raghu2008
- Aug 6th, 2008
You can schedule the task using unix shell scripting and crontab file inorder to execute it on specified time.
-
What is the global temporary variable
Raghu2008
- Aug 6th, 2008
A global variable is used to store charecter?value upto 255 in length. It can be access throught the form module. The global variable always prefixed with ':Global.'ThanksRaghu.
jagadeesh9
- Feb 22nd, 2008
We r write pl/sql procedure r packageonly that particular session we use global temparary table once the session complete then global temparary table will be delected automatically.syn:Create global temparary table(-----)
-
How will you pass whole query from Form builder to Report?
rajnish2008
- Sep 9th, 2008
You can create a record group using your query in the form. Then you can pass record group as data_parameter to the report. This way query in the report will get replaced by the record group query passed from forms.
-
How to convert the oracle reports to excel sheet from oracle form which is already parametrized on the basis of report's parameters?
-
What is purpose and order of firing the following triggers- on fetch- on select
bc_sumanamara
- Jan 12th, 2009
Fires when Form Builder would normally execute the open cursor, parse, and execute phases of a query, to identify the records in the database that match the current query criteria. FORM AND BLOCK LEVE...
liz
- Sep 13th, 2006
1)On select fires first.On select fFires when Forms Developer would normally execute the open cursor, parse, and execute phases of a query, to identify 2)On fetch fires nextWhen a query is first opene...
-
How do you trap default forms processing ( DML)
bc_sumanamara
- Jan 12th, 2009
ON-DELETE IS USER TO TRAP DEFAULT DML USED AT FORM LEVEL AND BLOCK LEVEL EXAMPLE : BEGIN UPDATE emp SET termination_date = SYSDATE WHERE emp...
ysumanth
- Oct 27th, 2005
Override on- triggers on insert /ondelete / on update
-
How add the values at run time to the report parameter ?dname:ename :Suppose i select dname(sales) , who belongs to that dname those employee name add to the ename
smithamd
- Jan 10th, 2006
By using add_parameter builtin you can add values to the report parameter at runtime
-
Lexical references
I am making an oracle 10g report and in Query Builder I tried to use lexical reference after the from clauselike SELECT ORDID, TOTALFROM &ATABLE;But it was showing me an error "invalid table name"Can't i use a lexical reference to make me enter the table name at run time?please help.
Rkhatri
- Feb 25th, 2009
It is working fine with Oracle 10g and even with 11gSQL>select &a, &b from &tablename;It will ask respective values and it work fine
jitendra_kumar
- Oct 31st, 2008
Lexical references is used to runtime dynamic where conditions. If you create query through query builder colon(:) must be used and this is used in after parameter form.
Jitendra kumar(software Engineer).
-
When execute query fire for a detail block and how many times pre query fire and how many times post query fire for a detail block?
D2K Interview Questions
Ans