Skip to main content

Spool command in oracle sql server

Spool is used to take script and its output in a file Example of spool SET sqlformat csv
spool c:\spoolfile.csv SELECT * FROM workorder;
spool off Example 2 SET SQLFORMAT SQL SPOOL 'C:\users\mysql.sql'; select * from asset; spool off You can use it also to create a insert script like select 'insert into Table values(Id=' + Id + ', name=' + name + ')' from Maxusers SET sqlformat csv
spool c:\spoolfile.csv select 'insert into Table values(Id=' + Id + ', name=' + name + ')' from Maxusers;
spool off Note : For running this you need to press F5 only because it runs as a batch file..

Comments

Post a Comment

Popular posts from this blog

Maximo Interview Questions - Maximo Technical and Functional Questions

Technical Questions How do you rate your self in :- 1. PL/SQL 2. Java 3. Automation Script 4. Mbo Customization 5. Admininstration Jobs 6. Funtional Concepts 7. Maximo Configuration Do not rate anything less than 7 unless you don't want interview to skip the topic Deployment / Administration  1. Explain LDAP integration? 2. Explain SSO and LTPA token? 3. What is global security? 4. How session is managed in Websphere or Maximo? 16. How to insert attributes from Backend? 5. How request is passed in Maximo? 6. How to do horizontal and vertical clustering? 7. Explain how you confire websphere for maximo manually? 8. What are Websphere MQ? 9. What is JMS, Connection Factory and Queues? 10. What is difference between vmm and ldap sync integration ? 11. What is Standalone and federated repository? 12. How to install a new language in Maximo? 13. What are the steps to apply a Fix pack in Maximo, Websphere or DB2? 14. Have you worked on any performance checking tools? 15
3 comments
Read more

Maximo Bean Class Methods

Methods of Bean Classes of Maximo Reset Method   This method is called when a new filter is applied for the dialog's MboSet.  @see psdi.webclient.system.beans.DataBean#reset()     @Override     public void reset() throws MXException     {             try         {                 saveCurrentSelection();         }         catch (RemoteException e)         {             handleRemoteException(e);         }         super.reset();     } Initialize It is used to initialize values on a dialog @Override     protected void initialize() throws MXException, RemoteException     {         uids = new ArrayList<Long>();         super.initialize();     } Call Method This method is called whenever an event is generated in the dialog (e.g. OK button is pressed). It is      overridden to merge all previously saved selections and reset the resulting MboSet accordingly.      *@see psdi.webclie
3 comments
Read more