Home » RDBMS Server » Server Administration » insert into....bla bla...select @@indentity as 'ID' ?
insert into....bla bla...select @@indentity as 'ID' ? [message #372258] Tue, 23 January 2001 02:59 Go to next message
ceppya
Messages: 1
Registered: January 2001
Junior Member
I'm new in oracle....
"Insert Into tblUser (User) Values ('ceppya') Select @@Identity as 'Id'", that's worked on SQL Server, please show me how to write that SQL command in Oracle..thanks

Report message to a moderator

Re: insert into....bla bla...select @@indentity as 'ID' ? [message #372317 is a reply to message #372258] Thu, 01 February 2001 16:19 Go to previous message
Gabriel
Messages: 11
Registered: February 2001
Junior Member
Hi!

CREATE TABLE film
(name CHAR(20),
studio VARCHAR2(20));

INSERT INTO film
VALUES('The Professional','Paramount');

SELECT * FROM film; (This selects all from film)
SELECT studio FROM film; (This select only the studio column)

Report message to a moderator

Previous Topic: Date Validation
Next Topic: time remaining(interval)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 00:20:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.