When you use CREATE TABLE AS SELECT, you do not name the columns of the table which you intend to create. You only name the columns of the table you are selecting from, or you can use * for all columns.
On Fri, Apr 19, 2013 at 1:18 AM, <shab.ras...@gmail.com> wrote: > 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<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 Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > 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 oracle-plsql+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com 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 oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
