PDA

View Full Version : ANSI SQL


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

  1. update query in pl/sql
  2. set field = current date
  3. Lowest Marks
  4. Discount-calculation
  5. Searching on friends, friends' friends, friends' friends' friends, ...
  6. Creating procedures in PL/SQL
  7. multiple-column subquery
  8. normal forms
  9. row exceptions in pl/sql
  10. Upload File
  11. Field looping
  12. PL/SQL Problem
  13. Help!!!
  14. Pagination in AS400 Stored Procedure
  15. How to improve this SQL statement?
  16. Used Disk Space
  17. Help BLOB
  18. SELECT Statement Help
  19. update recnos within groups
  20. Picking one row out of many?
  21. Keyword Search
  22. Oracle Financials Technical Lead
  23. Query Help
  24. Large DBs
  25. deleting from one table based on rows in another
  26. Search/Replace function for varchar2(2000) field
  27. Dynamic connect...?
  28. Using a column as a result in CASE statement
  29. FULL JOIN to distribute one column over several others
  30. Help with Oracle 8i Outer Join
  31. Help with Statement (PL/SQL)
  32. Running reports from forms 9i
  33. Raising an exception for "no rows selected"
  34. dQuery 3.0 or earlier
  35. How do I enumerate the database?
  36. can i make one query out of these two?
  37. store a query from a select statement into a variable
  38. Oracle, SQL+ and calling a stored proc in a package
  39. select statement w/case statement
  40. movie db query problems
  41. error using dbms.sql
  42. 9i XML extraction in "before" triggers
  43. question about searching
  44. HELP! - Call STORED PROCEDURE DB2 mainfraime
  45. SQL Student Guide
  46. More SQL Clean-Up
  47. run time error: Encountered the symbol "S" when expecting one of the following:
  48. better way to update then select
  49. Cleaning up bad Oracle 8i SQL; made it worse?
  50. what's wrong with my code? (Attaching an image)
  51. creating a text file from the contents of the database?
  52. Sorting question
  53. msde
  54. *pls help (3 day bug)* If statement not returning TRUE when it should
  55. Portable date (month + year) syntax
  56. database for portal
  57. Summing with field name
  58. Select Distinct
  59. Sql Statement Question
  60. Associative array
  61. some environmental variable in SQL*Plus
  62. Help need to write a Query in VB - MsSql !
  63. Portable way to express COUNT(DISTINCT list) ?
  64. Query a dynamic table...HELP!
  65. HELP!! - SQL Statement does not work!
  66. How to find the second largest value in a field !
  67. Sql Select...
  68. IN list returned by a function
  69. Table data type and ASP
  70. Triggers
  71. Default Password of Oracle SQL PLus
  72. Help with Dbms_output PLEASE!!!
  73. Questions about tables and SQL
  74. [multivalued DBMS] How can I make this SELECT?
  75. Attachment
  76. Using JOINS or just the WHERE clause
  77. Sql
  78. Union All & Group By
  79. Replacing Multiple rows with searched multiple values
  80. Returning small managable sets from a SELECT statement
  81. Extracting
  82. Need help creating a trigger
  83. SP2-0552: Bind variable "OLD" not declared.
  84. SQL Help
  85. Best Way To Create Point Of Sale Database
  86. SQL 2000 automated reports via e-mail
  87. Sending printer escape codes to UTL_FILE.PUT_LINE
  88. Dates and Loops question
  89. Beginning PL/SQL question
  90. Exceptions
  91. xmlparser Time-out (Oracle 8.1.7)
  92. Sql*plus okey... but Not Java
  93. Date Format
  94. Specify index for ra_site_uses_all <<URGENT>>
  95. oracle procedure help
  96. "missing expression"
  97. How to set Tab as column separator in SQL*Plus?
  98. Help! this is so basic for some of you!!!
  99. "NOT IN" vs "MINUS"
  100. SQL Help
  101. Dynamic SQL
  102. cursor is having no rows but should show at least 2
  103. pl/sql package will not compile
  104. procedure to create log and error files
  105. Big help is needed...
  106. Compbined into one select?
  107. query syntax problems
  108. Select text values
  109. CASE statement question
  110. query to return only non null fields
  111. Agg op question
  112. Shift a decimal
  113. Need some helps on this task
  114. Using variable as field name in record based on cursor
  115. To subquery or not to subquery?
  116. open recordset error
  117. 3 largest value
  118. SQL 7 Personal Edition on Laptop
  119. SQL Find Text - use like ?
  120. Connecting Sqlserver2000 To Db400
  121. Access sub-select question
  122. PL/SQL functions for binary data?
  123. A question on subquery return
  124. Enumeration variables???
  125. New column in where clause
  126. Insert records into unusual table
  127. missing or invalid option
  128. weekly to monthly
  129. PL/SQL cursors and index tables
  130. Data from two tables
  131. Newbie : Need help in Sorting
  132. RunTime Error 3706
  133. First & last record retrieve
  134. HELP! Stored Procedure problem
  135. Help with Select statement
  136. Turning one record into multiple records...
  137. External Procedure error
  138. Select last row in db atble
  139. pl/sql wrappers newbie guide?
  140. need to select date range in sql...not working..
  141. Data type mismatch in criteria expresioin
  142. anyone can help me?
  143. VBScript cannot call MS SQL SERVER Database record file?
  144. Is it possible to append and sum together?
  145. PL/SQL command to print a saved file in unix?
  146. table data for IN keyword
  147. trouble using ref cursors
  148. Stored Procedure Create Table from Variable
  149. php and mysql -- in chinese?
  150. Truncating part of a zip code
  151. Inserting data from multiple row into one?
  152. Sum and Count two tables
  153. UTL_FILE.PUT usage
  154. Passing contents of text file into variable?
  155. Dynamically substitute table name in Cursor Defn.
  156. Getting reading blob data from VB
  157. Normalisation Help
  158. SQL Select problem
  159. Newbie : Need Help in joining Multiple tables
  160. If Else question URGENT
  161. returning numeric values via sql!
  162. getting count of query??? how?
  163. inserting values for alias names within tables?
  164. Sumarized in SQL
  165. Passing HTP.PRINT statements into a variable
  166. Changing Character Case
  167. Stored Procedures?
  168. PL/SQL & Recordsets
  169. Is there a statement to view table description in MS SQL
  170. Converting SQL Scripts.
  171. How to return only the first row....
  172. Syntax Usage of DISTINCT ?
  173. pls/sql help needed urgent.
  174. Stupid Question
  175. Pls-00378
  176. small basic question concerning count
  177. Dynamic Dates and Stored Procedures
  178. A practical newbie question involving r/s schema involving mysql
  179. Dates and Differences between Query Analyzer and Enterprise Manager
  180. column formula
  181. Jet 3.5 ADD COLUMN position?
  182. Query Help
  183. Load File In A Table
  184. Retaining results from a query (in a temp table?)
  185. perl DBI update
  186. Using "&" in a search string HELP!!
  187. Data type mismatch in criteria expression.
  188. Matrix / Crosstab Query
  189. how to put the result of a query into a variable??
  190. Help with referential triggered actions!
  191. inietinfo entry point not found
  192. creating constraints
  193. How to control MS SQL Server DataBase's permissions through visual basic programing
  194. UTL_FILE in RDB (OpenVMS)
  195. A new PL/SQL nut...
  196. What's wrong with this pl/sql procedure???
  197. client server sql
  198. Questions on WHILE LOOP in PL/SQL
  199. problems with SQL inn Win 2000 and XP,again
  200. Pass error sql to ksh
  201. How to set format of Excel column while generating report in Excel?
  202. Help me please with SQL!!!!!!!!!!!!!!!!
  203. Problem calling Oracle SP from Access 97
  204. Query AS400 Column Names
  205. execute ie instance
  206. activex on oracle forms
  207. Mulitple Update in mYSQL
  208. problem about Pro*C
  209. Trigger help - Please :)
  210. Formating column widths with SQLPlus
  211. Sql Default Date Format
  212. Get index of values in buffer in a SP
  213. Cursor limits
  214. A+b=c
  215. Querying all the constraints in a database
  216. Autonumber problem Error "Data type mismatch in criteria expression"
  217. converting from Oracle to SQL Server
  218. Diagram Script I Sql7
  219. Triggers, procedures and inserting into a table
  220. A Matter of Style
  221. How to make UDF deterministic
  222. SQL Syntax error with a float
  223. Duplicate Records
  224. UPDATE multiple rows with values from another table
  225. Need help with a 3 table query
  226. Creating backup table
  227. sql report
  228. pass sql error to ksh
  229. Cannot resolve collation conflict for equal to operation.
  230. comparing tables
  231. Displaying Date in SQL View
  232. SQL and access 97
  233. UPDATE question
  234. MySql
  235. Create Cursor with Dynamic SQL
  236. SQL search spanning mutliple servers
  237. CreateFile() Error
  238. Removing headers from sql output
  239. Want to get any 10 records from resultset
  240. Rank with median on ties
  241. sql help
  242. Export query in text file
  243. REPLACE Function for Bad Characters?
  244. Novice Seeks Book Advice
  245. How do I?
  246. reading user input?
  247. Consolidating Like Items and Summing Totals
  248. Calling a pl/sql func with OCI - please help
  249. Problem SQL select statement
  250. populating a primary key using a before insert trigger