Click here to Skip to main content
15,559,155 members
Home / Discussions / Database
   

Database

 
GeneralRe: DateTime _Oct2007 Pin
Colin Angus Mackay30-Oct-07 4:05
Colin Angus Mackay30-Oct-07 4:05 
GeneralRe: DateTime _Oct2007 Pin
r a j u u30-Oct-07 4:10
r a j u u30-Oct-07 4:10 
GeneralRe: DateTime _Oct2007 Pin
Colin Angus Mackay30-Oct-07 4:24
Colin Angus Mackay30-Oct-07 4:24 
GeneralRe: DateTime _Oct2007 Pin
soni uma30-Oct-07 3:09
soni uma30-Oct-07 3:09 
GeneralRe: DateTime _Oct2007 Pin
r a j u u30-Oct-07 3:18
r a j u u30-Oct-07 3:18 
QuestionProblem with GetSchemaTable Pin
stofel30-Oct-07 1:22
stofel30-Oct-07 1:22 
AnswerRe: Problem with GetSchemaTable Pin
andyharman30-Oct-07 8:21
professionalandyharman30-Oct-07 8:21 
AnswerRe: Problem with GetSchemaTable Pin
stofel30-Oct-07 22:50
stofel30-Oct-07 22:50 
Hi,

Select * from (select name from employee) is a legal statement, OracleClient and Toad could execute it.
I could by-pass it, I change

OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo);

into
OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

But their I don't get the basistablename even in a normal select.

Tanks
Willibert
QuestionNeed query Pin
micydon30-Oct-07 1:01
micydon30-Oct-07 1:01 
AnswerRe: Need query Pin
r a j u u30-Oct-07 1:24
r a j u u30-Oct-07 1:24 
AnswerRe: Need query Pin
Senu Gandhi30-Oct-07 1:32
Senu Gandhi30-Oct-07 1:32 
QuestionTimeout expired Pin
Senu Gandhi30-Oct-07 0:36
Senu Gandhi30-Oct-07 0:36 
AnswerRe: Timeout expired Pin
Nic Rowan30-Oct-07 0:57
Nic Rowan30-Oct-07 0:57 
GeneralRe: Timeout expired Pin
Senu Gandhi30-Oct-07 1:23
Senu Gandhi30-Oct-07 1:23 
GeneralRe: Timeout expired Pin
Nic Rowan30-Oct-07 1:29
Nic Rowan30-Oct-07 1:29 
AnswerRe: Timeout expired Pin
r a j u u30-Oct-07 1:08
r a j u u30-Oct-07 1:08 
GeneralRe: Timeout expired Pin
r a j u u30-Oct-07 1:10
r a j u u30-Oct-07 1:10 
GeneralRe: Timeout expired Pin
Senu Gandhi30-Oct-07 1:26
Senu Gandhi30-Oct-07 1:26 
AnswerRe: Timeout expired Pin
GuyThiebaut30-Oct-07 4:36
professionalGuyThiebaut30-Oct-07 4:36 
QuestionSQL UDF Remoting Pin
Nic Rowan30-Oct-07 0:02
Nic Rowan30-Oct-07 0:02 
AnswerRe: SQL UDF Remoting Pin
andyharman30-Oct-07 8:15
professionalandyharman30-Oct-07 8:15 
QuestionCursor_sql server 2005 Pin
r a j u u29-Oct-07 22:51
r a j u u29-Oct-07 22:51 
AnswerRe: Cursor_sql server 2005 Pin
neeraj_indianic29-Oct-07 23:33
neeraj_indianic29-Oct-07 23:33 
GeneralRe: Cursor_sql server 2005 Pin
r a j u u30-Oct-07 0:30
r a j u u30-Oct-07 0:30 
GeneralRe: Cursor_sql server 2005 Pin
Navdeep Bhardwaj30-Oct-07 1:10
Navdeep Bhardwaj30-Oct-07 1:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.