Показать сообщение отдельно

  #8  
Старый 06.01.2008, 11:25
Noiro
Познающий
Регистрация: 01.01.2008
Сообщений: 50
С нами: 9662713

Репутация: 71
По умолчанию

Цитата:
Сообщение от Spyder  
вы синтаксиса sql походу вообще не знаете
Цитата:
Сообщение от Spyder  
Дело в том что надо указывать только имя таблицы, без имени бд в которой она находится +)
Цитата:
Сообщение от ISO/IEC 9075:1992, Database Language SQL  
Base tables and views are identified by <table name>s. A <table
name> consists of a <schema name> and an <identifier>. For a per-
sistent table, the <schema name> identifies the schema in which
the base table or view identified by the <table name> was de-
fined. Base tables and views defined in different schemas can
have <identifier>s that are equal according to the General Rules
of Subclause 8.2, "<comparison predicate>".

If a reference to a <table name> does not explicitly contain a
<schema name>, then a specific <schema name> is implied. The par-
ticular <schema name> associated with such a <table name> depends
on the context in which the <table name> appears and is governed
by the rules for <qualified name>. The default schema for <prepara-
ble statement>s that are dynamically prepared in the current SQL-
session through the execution of <prepare statement>s and <execute
immediate statement>s is initially implementation-defined but may
be changed by the use of <set schema statement>s.
 
Ответить с цитированием