PDA

View Full Version : ANSI SQL


Pages : 1 [2] 3 4 5 6 7 8 9

  1. Using variable as field name in record based on cursor
  2. Need some helps on this task
  3. Shift a decimal
  4. Agg op question
  5. query to return only non null fields
  6. CASE statement question
  7. Select text values
  8. query syntax problems
  9. Compbined into one select?
  10. Big help is needed...
  11. procedure to create log and error files
  12. pl/sql package will not compile
  13. cursor is having no rows but should show at least 2
  14. Dynamic SQL
  15. SQL Help
  16. "NOT IN" vs "MINUS"
  17. Help! this is so basic for some of you!!!
  18. How to set Tab as column separator in SQL*Plus?
  19. "missing expression"
  20. oracle procedure help
  21. Specify index for ra_site_uses_all <<URGENT>>
  22. Date Format
  23. Sql*plus okey... but Not Java
  24. xmlparser Time-out (Oracle 8.1.7)
  25. Exceptions
  26. Beginning PL/SQL question
  27. Dates and Loops question
  28. Sending printer escape codes to UTL_FILE.PUT_LINE
  29. SQL 2000 automated reports via e-mail
  30. Best Way To Create Point Of Sale Database
  31. SQL Help
  32. SP2-0552: Bind variable "OLD" not declared.
  33. Need help creating a trigger
  34. Extracting
  35. Returning small managable sets from a SELECT statement
  36. Replacing Multiple rows with searched multiple values
  37. Union All & Group By
  38. Sql
  39. Using JOINS or just the WHERE clause
  40. Attachment
  41. [multivalued DBMS] How can I make this SELECT?
  42. Questions about tables and SQL
  43. Help with Dbms_output PLEASE!!!
  44. Default Password of Oracle SQL PLus
  45. Triggers
  46. Table data type and ASP
  47. IN list returned by a function
  48. Sql Select...
  49. How to find the second largest value in a field !
  50. HELP!! - SQL Statement does not work!
  51. Query a dynamic table...HELP!
  52. Portable way to express COUNT(DISTINCT list) ?
  53. Help need to write a Query in VB - MsSql !
  54. some environmental variable in SQL*Plus
  55. Associative array
  56. Sql Statement Question
  57. Select Distinct
  58. Summing with field name
  59. database for portal
  60. Portable date (month + year) syntax
  61. *pls help (3 day bug)* If statement not returning TRUE when it should
  62. msde
  63. Sorting question
  64. creating a text file from the contents of the database?
  65. what's wrong with my code? (Attaching an image)
  66. Cleaning up bad Oracle 8i SQL; made it worse?
  67. better way to update then select
  68. run time error: Encountered the symbol "S" when expecting one of the following:
  69. More SQL Clean-Up
  70. SQL Student Guide
  71. HELP! - Call STORED PROCEDURE DB2 mainfraime
  72. question about searching
  73. 9i XML extraction in "before" triggers
  74. error using dbms.sql
  75. movie db query problems
  76. select statement w/case statement
  77. Oracle, SQL+ and calling a stored proc in a package
  78. store a query from a select statement into a variable
  79. can i make one query out of these two?
  80. How do I enumerate the database?
  81. dQuery 3.0 or earlier
  82. Raising an exception for "no rows selected"
  83. Running reports from forms 9i
  84. Help with Statement (PL/SQL)
  85. Help with Oracle 8i Outer Join
  86. FULL JOIN to distribute one column over several others
  87. Using a column as a result in CASE statement
  88. Dynamic connect...?
  89. Search/Replace function for varchar2(2000) field
  90. deleting from one table based on rows in another
  91. Large DBs
  92. Query Help
  93. Oracle Financials Technical Lead
  94. Keyword Search
  95. Picking one row out of many?
  96. update recnos within groups
  97. SELECT Statement Help
  98. Help BLOB
  99. Used Disk Space
  100. How to improve this SQL statement?
  101. Pagination in AS400 Stored Procedure
  102. Help!!!
  103. PL/SQL Problem
  104. Field looping
  105. Upload File
  106. row exceptions in pl/sql
  107. normal forms
  108. multiple-column subquery
  109. Creating procedures in PL/SQL
  110. Searching on friends, friends' friends, friends' friends' friends, ...
  111. Discount-calculation
  112. Lowest Marks
  113. set field = current date
  114. update query in pl/sql
  115. Effective Date selection in SQL
  116. stored procedure update
  117. query help
  118. creating stored procedure update
  119. Joins Across Servers/Databases
  120. Initial Caps of a String value
  121. add_months function
  122. impossible SQL query???
  123. Outer Join and Inner Join
  124. NOOB ??? Thing to ask
  125. Returning the entered date
  126. Converting a (+) to an outer join in SQLServer
  127. One last before the week end
  128. Returning text as a Parameter
  129. Begins With
  130. Help!!
  131. PL/SQL Help!!
  132. sqlj help
  133. How to create spool in PL/SQL
  134. MSDE crash recovery
  135. procedure
  136. Oracle 8i SQL Help
  137. Sql statement for SPSS syntax editor
  138. Date Range Search Problem
  139. problem with DBMS_AQ
  140. How to pass array of strings in stored procedure (Oracle)?
  141. Oracle SQL tutorials
  142. DB Help!!!!!
  143. Auto Number Data Type?
  144. Rounding error....
  145. SQL statement comparison
  146. SQL Query question
  147. Please Help!! Pl/sql
  148. Nested Query Question
  149. Inserting an unique row count
  150. Using Access Query in SQL
  151. Hit Outlook contacts database (API?)
  152. Remove Duplicate Data but Keep One
  153. Removing 'duplicates' in Paired Data
  154. How to return a result from a procedure?
  155. Computed Column "smalldatetime" from 3 separate columns?
  156. Multiple Rows
  157. Simple SQL query
  158. Creating Triggers
  159. Easy (?) data-editing solution? Need help pls.
  160. How to Parse GET_LINE input ?
  161. dynamic sql doesn't work?
  162. erase HTML tag
  163. HELP with Pro*C and RECORD type
  164. Time Insert Into Error
  165. Submitting forms to a PL/SQL procedure.
  166. Subquery?
  167. Querying 2 tables for results
  168. Basic Join Question
  169. Auto_increment
  170. How pattern searching on Arabic data can be possible with SQL
  171. Is possible of using one single statement for inserting two tables?
  172. Receive java.io.InputStream frm PL/SQL
  173. using parameter from procedure to generate SQL statement
  174. Triger
  175. SQL Trigger updates occasionally
  176. DBMS_SQL package
  177. Bad data
  178. Client Access AS400 ODBC
  179. help in getting data from multiple table joins
  180. Alter Table
  181. group by query
  182. Joining Different Datatypes
  183. Simple question; simple answer?
  184. where should I post WEB PL/SQL questions?
  185. index creation
  186. type date
  187. OWA.VC_ARR how does it work?
  188. Sql Plz He[p!!
  189. set explain on
  190. trigger
  191. Need to create a SQL statement to reformat data
  192. Returning decimal places using Datediff
  193. New to using SQL with Oracle
  194. Problems with simple procedure
  195. clike
  196. error ora -00937
  197. Insert Java-class from script
  198. may i have a SIMPLE and COMPLETE PL/sql program?
  199. Jdbc
  200. Order By
  201. simple question
  202. PL/SQL for searching
  203. Get the system date format?
  204. trim spaces between words of a string
  205. SQLanywhere 5.0 - ODBC Driver
  206. date question
  207. how to sort
  208. SQL Query Question
  209. select records from one table & remaining from the other
  210. Monitoring a particular Table as soon as my Webserver(Application Server) is up.
  211. How to make this join select statement works
  212. Recursion in PL/SQL
  213. PL/SQL effeciency question
  214. Help!!!
  215. Link two tables in UPDATE - ERR:single-row subquery returns more than one row
  216. find Minimum in range thats not in Table?
  217. SQL query
  218. Update records on a Select
  219. Inserting Values into Oracle Objects
  220. Oracle Objects
  221. Double Left Join?
  222. function to create table
  223. Export record from Oracle to SQL Server on insert
  224. Oracle PL/SQL Date Function
  225. Loading flat file to oracle table?
  226. Writing Generic Stored Procedures for MS SQL and ORACLE
  227. First Timer having an INSERT Problem
  228. invalid row id
  229. Creating Stored procedures
  230. AS/400 SQL Error (VB Script)
  231. Strange behaviour from NO_DATA_FOUND
  232. Take pity on a PL/SQL newbie-help!!!
  233. Store Procedure to Increment Fields
  234. dbo.rndnum
  235. How to do this conditional(maybe?) query
  236. help required sql query challenge
  237. How can I do this conditional Where Clause?
  238. alter table.. foreign key
  239. SQL question
  240. Recordset Modification and Copy
  241. pass variables to the sql
  242. I wanted to use COLLATE within CONTAINS
  243. problem with using String Variable in IN Function
  244. How to create html form using loop?
  245. As of Date Function
  246. Caching results of Stored Procedure
  247. SQL Query - How to ?
  248. Brand New to SQL and Programing
  249. Brand New to SQL and Programing
  250. Does ODBC standard SQL grammar exist ?