what code i will use in asp.net to insert,update,delete & select data into oracle 10g..
vinaysrk919 0 Newbie Poster
crazyvonzipper 0 Newbie Poster
Oracle scripts are similar to T-SQL scripts, you should be able to do basic insert update select and delete commands in the same manner.
this will apply to MySQL, ACCESS , EXCEL and PostgreSQL - SQLite.
SELECT COMMAND :
SELECT [column1], [column2] FROM [Table] WHERE ....
INSERT COMMAND :
INSERT INTO [Table]( [column1], [column2] ) VALUES ( 'Value1' , 'Value2' )
UPDATE COMMAND :
UPDATE [Table] SET [column1] = 'Value1', [column2] = 'Value2' WHERE ....
DELETE COMMAND :
DELETE FROM [Table] WHERE ....
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.