Two Laptop Bag
The moose likes JSP and the fly likes execute Create table statement  from JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Java » JSP
Reply 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...
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: execute Create table statement from JSP
 
Similar Threads
Help a beginner create a database! ;-)
statement is not executing on setString
multiple primary key exception
create table.. which method?
Creating Tables