You Want To Use SQL To Build SQL, What Is This Called And Give An Example

You Want To Use SQL To Build SQL, What Is This Called And Give An Example


  • 7 Feb, 2012

    This is called dynamic SQL. An example would be:set lines 90 pages 0 termout off feedback off verify offspool drop_all.sqlselect ?drop user ?||username||? cascade;? from dba_userswhere username not in ("SYS?,?SYSTEM?);spool offEssentially you are looking to see that they know to include a command (in this case DROP USER...CASCADE;) and that you need to concatenate using the ?||? the values selected from the database.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.