Hi all... just new in plsql as well just want to ask 1 question, do i need the same field in my destination table if i want to used this code... or the all the field will be copy automatically from the source table location..?
thanks in advance for helping... On Friday, March 24, 2006 6:46:08 PM UTC+8, dt wrote: > > > I am glad I could help. > > If you're interested in extending your knowledge little further, you > may want to learn how to update an entire row you with a record. > > See examples taken from this site (way further down you can find > another link to "insert" reference): > http://www.psoug.org/reference/update.html > > > CREATE TABLE t AS > SELECT table_name, tablespace_name > FROM all_tables; > > SELECT DISTINCT tablespace_name > FROM t; > > DECLARE > trec t%ROWTYPE; > BEGIN > trec.table_name := 'DUAL'; > trec.tablespace_name := 'NEW_TBSP'; > > UPDATE t > SET ROW = trec > WHERE table_name = 'DUAL'; > > COMMIT; > END; > / > > SELECT DISTINCT tablespace_name > FROM t; > > -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
