*
The moose likes JSP and the fly likes execute Create table statement  from JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » JSP
Bookmark "execute Create table statement  from JSP " Watch "execute Create table statement  from JSP " New topic
Author

execute Create table statement from JSP

Confused
Ranch Hand

Joined: Jan 24, 2006
Posts: 54
Can I execute Create table statement from my jsp app..
like da way i execute insert or update statement...
lakshmi v.samy
Ranch Hand

Joined: Feb 02, 2006
Posts: 30
Sure we can execute create,update,insert statements in jsp page
Confused
Ranch Hand

Joined: Jan 24, 2006
Posts: 54
Can u give me the systax Plz ...
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Below is the query syntax for ORACLE.

CREATE TABLE table-name
(
emp-no NUMBER(5),
emp-name VARCHAR2(50),
dept-no NUMBER(5)
)

[edited]
Just pass this statement like you pass insert or update statements.
[ February 24, 2006: Message edited by: Adeel Ansari ]
Confused
Ranch Hand

Joined: Jan 24, 2006
Posts: 54
Thanks its done...
 
GeeCON Prague 2014
 
subject: execute Create table statement from JSP