Close Menu Navigation
Open Categories Menu Oracle SQL Syntax
- 6 Januar, 2012 -
- Entwicklung -
- Tags :
- 0 Comments
As I tend to forget the syntax of Oracle SQL commands, I will write them down here, every time I have to look them up. Beginning now:
Turn off variable replacement in SQL+
set define off;
Drop Column
alter table <tablename> drop column <column_name>
Also look here.
Rename Column
alter table <tablename> rename column <column_name_old> to <column_name_new>;
Using SQL+ Command Line tool
Connect:
connect scott/tiger
Excecute a sql-file
@path/to/myscript.sql
also see this
