What is an UTL_FILE.What are different procedures and functions associated with it?

What is an UTL_FILE.What are different procedures and functions associated with it?
by

1 Answer

Answer :

UTL_FILE is a package that adds the ability to read and write to
operating system files. Procedures associated with it are FCLOSE,
FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE,
NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE.
Functions associated with it are FOPEN, ISOPEN.
by

Related questions

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What is difference between Procedures and Functions ?

Description : What is difference between Procedures and Functions ?

Last Answer : A Function returns a value to the caller where as a Procedure does not.

How packaged procedures and functions are called from the following?

Description : How packaged procedures and functions are called from the following?

Last Answer : a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS?? a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME ( ... .PROCEDURE if the procedures does not have any out/in-out parameters. A function can not be called.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

What is Overloading of procedures ?

Description : What is Overloading of procedures ?

Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

What are advantages fo Stored Procedures?

Description : What are advantages fo Stored Procedures?

Last Answer : Extensibility,Modularity, Reusability, Maintainability and one time compilation.

What are the unrestricted procedures used to change the popup screen position during run time ?

Description : What are the unrestricted procedures used to change the popup screen position during run time ?

Last Answer : Anchor-view Resize -View Move-View.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

What are stand-alone procedures?

Description : What are stand-alone procedures?

Last Answer : Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These ... limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

What are stored-procedures? And what are the advantages of using them.

Description : What are stored-procedures? And what are the advantages of using them.

Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

Explain the use of table functions.

Description : Explain the use of table functions.

Last Answer : Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

What are Procedure,functions and Packages

Description : What are Procedure,functions and Packages

Last Answer : Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not ... Provide a method of encapsulating and storing related procedures, functions, variables and other Package Contents

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

What are the built-ins used for finding object ID functions?

Description : What are the built-ins used for finding object ID functions?

Last Answer : Find_group(function) Find_column(function)

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

What are the triggers associated with a check box?

Description : What are the triggers associated with a check box?

Last Answer : Only When-checkbox-activated Trigger associated with a Check box.

What triggers are associated with the radio group?

Description : What triggers are associated with the radio group?

Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.

What are the triggers associated with the image item?

Description : What are the triggers associated with the image item?

Last Answer : When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)

What are built-ins associated with timers?

Description : What are built-ins associated with timers?

Last Answer : find_timercreate_timerdelete_timer

What are the two repeating frame always associated with matrix object?

Description : What are the two repeating frame always associated with matrix object?

Last Answer : One down repeating frame below one across repeating frame.

What are the trigger associated with image items?

Description : What are the trigger associated with image items?

Last Answer : When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item

What is trigger associated with the timer?

Description : What is trigger associated with the timer?

Last Answer : When-timer-expired.

Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the internal auditor. b. The external audit function's objectives vary according to management's requirements. c. Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures. d. The external auditor is responsible for the audit opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Description : Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the ... opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Last Answer : Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures.

The term module in the design phase refers to ? Functions Procedures Sub programs All of the above

Description : The term module in the design phase refers to ? Functions Procedures Sub programs All of the above

Last Answer : All of the above

Defects discovered by static analysis tools include: i. Variables that are never used. ii. Security vulnerabilities. iii. Programming Standard Violations iv. Uncalled functions and procedures a) i , ii,iii,iv is correct b) iii ,is correct I,ii,iv are incorrect. c) i ,ii, iii and iv are incorrect d) iv, ii is correct

Description : Defects discovered by static analysis tools include: i. Variables that are never used. ii. Security vulnerabilities. iii. Programming Standard Violations iv. Uncalled functions and procedures a) i , ii,iii,iv is correct b ... ,iv are incorrect. c) i ,ii, iii and iv are incorrect d) iv, ii is correct

Last Answer : a) i , ii,iii,iv is correct

When a CPA who is not independent is associated with financial statements, he would be precluded from expressing an opinion becausea. The public would be aware of his lack ofindependence and would place little orno faith in his opinion.b. He would place himself in the position ofsuffering an adverse decision in apossible liability suit.c. He would be in the position of auditinghis own work.d. Any auditing procedures he mightperform would not be in accordancewith generally accepted auditingstandards

Description : When a CPA who is not independent is associated with financial statements, he would be precluded from expressing an opinion becausea. The public would be aware of his lack of ... Any auditing procedures he might perform would not be in accordance with generally accepted auditing standards

Last Answer : Any auditing procedures he might perform would not be in accordance with generally accepted auditing standards

What is Software ? Set of computer programs, procedures and possibly associated document concerned with the operation of data processing. A set of compiler instructions A mathematical formula None of above

Description : What is Software ? Set of computer programs, procedures and possibly associated document concerned with the operation of data processing. A set of compiler instructions A mathematical formula None of above

Last Answer : Set of computer programs, procedures and possibly associated document concerned with the operation of data processin

The nurse anticipates that the immunosuppressed patient is at greatest risk for which type of shock? a) Septic Septic shock is associated with immunosuppression, extremes of age, malnourishment, chronic illness, and invasive procedures. b) Neurogenic Neurogenic shock is associated with spinal cord injury and anesthesia. c) Cardiogenic Cardiogenic shock is associated with disease of the heart. d) Anaphylactic Anaphylactic shock is associated with hypersensitivity reactions.

Description : The nurse anticipates that the immunosuppressed patient is at greatest risk for which type of shock? a) Septic Septic shock is associated with immunosuppression, extremes of age, ... disease of the heart. d) Anaphylactic Anaphylactic shock is associated with hypersensitivity reactions.

Last Answer : a) Septic Septic shock is associated with immunosuppression, extremes of age, malnourishment, chronic illness, and invasive procedures.

What are the different objects that you cannot copy or reference in object groups?

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the Different Optimisation Techniques

Description : What are the Different Optimisation Techniques

Last Answer : The Various Optimisation techniques are a) Execute Plan :: we can see the plan of the query and change it accordingly based on the indexes b) Optimizer_hint :: set_item_property('DeptBlock', ... SQL statements reuse the cursor. f45run module = my_firstform userid = scott/tiger optimize_Tp = No

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are different Oracle database objects?

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What are the different methods of backing up oracle database ?

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

What are the different kind of export backups?

Description : What are the different kind of export backups?

Last Answer : Full back - Complete database Incremental - Only affected tables from last incremental date/full backup date. Cumulative backup - Only affected table from the last cumulative date/full backup date.

What are different types of images?

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

Can one import/export between different versions of Oracle? (for DBA

Description : Can one import/export between different versions of Oracle? (for DBA

Last Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.