Home » SQL & PL/SQL » SQL & PL/SQL » Inserting column
Inserting column [message #208700] Mon, 11 December 2006 23:11 Go to next message
sridharbireddy
Messages: 25
Registered: September 2006
Junior Member
how to insert a colummn value like 'ramu' by using single insert statement

[Updated on: Mon, 11 December 2006 23:16]

Report message to a moderator

Re: Inserting column [message #208705 is a reply to message #208700] Mon, 11 December 2006 23:19 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
if i am understand right you want like


insert into &table_name values ('ramu');
Re: Inserting column [message #208712 is a reply to message #208700] Mon, 11 December 2006 23:32 Go to previous messageGo to next message
rameshuddaraju
Messages: 69
Registered: June 2005
Location: India
Member

If your table does not contains not null constraints,primry key for the columns then you can insert a column value as follows

insert into your_table_name(your_column_name)values('ramu')


Re: Inserting column [message #210136 is a reply to message #208712] Tue, 19 December 2006 09:40 Go to previous messageGo to next message
sridharbireddy
Messages: 25
Registered: September 2006
Junior Member
I want to insert a coulmn like ramu with single qotes, that colummn must appeared in table like 'ramu'
Re: Inserting column [message #210153 is a reply to message #210136] Tue, 19 December 2006 12:26 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
use '''ramu'''

Are you really sure you want it like that?
Re: Inserting column [message #210158 is a reply to message #208700] Tue, 19 December 2006 13:09 Go to previous messageGo to next message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
Having mixed case columns in oracle tables is a VERY bad idea. Every time in every application that you reference that column, you will be forced to reference it as "ramu"
Re: Inserting column [message #210274 is a reply to message #210158] Wed, 20 December 2006 02:10 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It is a really bad idea. The only justification I've ever seem for this is when dealing with some MS products that insist on writing " enclosed column names and putting them in mixed case, and even in those cases, you'd be better off creating a set of views in mixed case over a set of decently named underlying tables.
Previous Topic: row into column
Next Topic: Removal of more than two duplicates..
Goto Forum:
  


Current Time: Sat Dec 03 18:12:42 CST 2016

Total time taken to generate the page: 0.08679 seconds