You Want To Use SQL To Build SQL, What Is This Called And Give An Example
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.
2009-2016 downloadmela.com. All rights reserved.