SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 creating table statement gets stuck
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Codname47
Starting Member

4 Posts

Posted - 08/25/2010 :  16:02:32  Show Profile  Reply with Quote
Hi everyone, i can use "select" statements without any problem but when i want to create a table with 100-1000 rows, it gets stuck and never returns and after i close the sql navigator and restart it, it creates my table easily but after 20-30 seconds when i want to create an another table, it stucks again. What can be the problem??(At the first times that i use sql, there was no problem)

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/25/2010 :  16:08:01  Show Profile  Visit tkizer's Homepage  Reply with Quote
You've posted your question on a Microsoft SQL Server forum. It seems you are using Oracle, is that correct?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Codname47
Starting Member

4 Posts

Posted - 08/25/2010 :  16:18:18  Show Profile  Reply with Quote
yes, it's correct so what should i do:)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/25/2010 :  16:19:25  Show Profile  Visit tkizer's Homepage  Reply with Quote
I don't know, we don't specialize in Oracle here. You should post your question on a site that deals with Oracle, such as the one on dbforums.com or how about the Oracle site.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Codname47
Starting Member

4 Posts

Posted - 08/25/2010 :  16:25:20  Show Profile  Reply with Quote
what about this question:)
Is there any way that i put a spesific column's data(only one data) into a variable??
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/25/2010 :  16:26:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
Here's how you'd do it in Microsoft SQL Server (it won't work in Oracle):

DECLARE @d datetime

SELECT @d = Column1
FROM Table1
WHERE Table1Id = 1

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Codname47
Starting Member

4 Posts

Posted - 08/25/2010 :  16:31:12  Show Profile  Reply with Quote
Everything's hard in this oracle i don't understand why the hack that my company uses that oracle!! anyway thanks a lot..
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 08/25/2010 :  18:33:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
That's why Oracle DBAs get paid more.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000