View Full Version : answers

Pages : 1 2 3 4 5 6 7 [8] 9 10 11 12 13 14
  1. How to connect oracle data base from unix shell script
  2. ORACLE 9i
  3. changing column data
  4. Outer join problem
  5. New PL/SQL Feature in Oracle 11g: CONTINUE keyword
  6. how to include other users in the password file...?
  7. How to run cron tab jobs in sql environment
  8. Store file in database tables
  9. Migration from oracle7 to oracle 9i
  10. Control file could not be located
  11. Global temporary table
  12. NULL values & UNIQUE Key
  13. oracle10g data in ISO-8859-1
  14. oracle
  15. transelate this scripts
  16. Oracle 9i license key -
  17. Create a Funtion to Increment a 7 digit number and call it from a stored proc
  18. com1 data control
  19. Character Report
  20. Row exclusive lock
  21. Getting ORA-01003 error
  22. Parallel Execution
  23. What is the difference between current_date & sysdate function?
  24. Exception In Ref Cursor
  25. Including records in a query result that have no values
  26. Getting Missing Values in the List
  27. stored procedure
  28. data migration
  29. Database doesnot strat automatically
  30. Oracle-Report Writing
  31. Oracle-Query
  32. Procedure explaination
  33. What is the use of command TNSPING?
  34. please help me
  35. ORA-12162 TNS:net service name is incorrectly specified
  36. Trying To Acquire Oracle 8 Enterprise
  37. end of communication channel
  38. Database migration
  39. Help in Query
  40. Handle db events in external programming application
  41. what happened when increasing the size of redologs
  42. alter a co-dependent type
  43. Date and hour in stored procedure
  44. Query
  45. Global Temporary Table
  46. Updating table columns with where exist
  47. how to select rows where column with date is NULL
  48. Procedure
  49. ORA-00917: missing comma error
  50. somi
  51. ORA-00911: invalid character
  52. Trigger on bulk insert
  53. Oracle stored Procedure
  54. About performance tuning
  55. giude me
  56. "NOT IN" performance
  57. write a query row to column
  58. Drop a schema ?
  59. Why The Function cannot be called
  60. Duplicate Removing
  61. How To Find Termination Value
  62. Insert data from pl/sql table in Oracle
  63. Its very very urgent Please....Could you please help.plz help in solving queries
  64. Explain
  65. Charset In Oracle 10g
  66. plz send me aquery about sind months , days between two dates
  67. unload data
  68. report
  69. Grouping sequential numbers with SQL
  70. how populate list item
  71. how can we call the word document by using forms
  72. Trigger giving exception ORA-04091
  73. Report Writing on Oracle
  74. Report Writing
  75. What is error PLW 07204?
  76. Calling functions
  77. how to take hot back up oracle 8i windows 2000 server
  78. PL/SQL - changing one column's value depending another column's value
  79. Help in group by query
  80. revoke permission from another users schema
  81. sqlplus not working
  82. system privileges
  83. SQLplus
  84. tell me about tablespace??????and waht is schemaa???????
  85. REG Apps
  86. how to handle invalid objects
  87. Tns-12560: Tns Protocol Adapter Error
  88. will a primary key change be reflected in the existing records?
  89. Could anyone help me in writing triggers? Plzz
  90. about system privileges
  91. plz help me in dis query...
  92. Triggers
  93. Urgent............Plzzzzzz help me in dis
  94. Data Migration
  95. I m a fresher in oracle plz help me in solving these queries.. plz provide tips also
  96. ORA-06502: PL/SQL: numeric or value error
  97. help needed for litner creation and new username creation!!!!!!!
  98. sql * plus
  99. disconnect from a user
  100. trying to connect to database
  101. How Oracle 10g searching Queries?
  102. Sql Dynamically
  103. Converting Timestamp to date.
  104. Special guidelines for Oracle forum.
  105. Oracle roles
  106. Strings Length Issue
  107. dat
  108. what is listner in oracle?????i want to create it on my pc!!!!!!
  109. About creating user,deleting user and revoke privileges
  110. Need Query.. Help Please...
  111. help needed for developer2000 installation!!!!!!it's urgent
  112. code explaination
  113. deadlock situation
  114. Therminal Printer Does Not Cut Automatically My Character Report
  115. Global Temprary Tables
  116. Difference between sys_user and system_user?
  117. converting German char into english
  118. Partitions
  119. store procedure for birthday
  120. writing text on new lines
  121. if a data field contains acomma in it then how load it using sqlloader
  122. Segment.....
  123. temporary tablespace
  124. Index on multivalue varchar2 field
  125. Oracle Books
  126. Tempfile offline
  127. check decode fuction for ae,ext,gen and check joining
  128. Update time stamp for CLOB Data
  129. Moving Data In Alike Columns From Table To Table
  130. Can some please sort out my query
  131. Oracle 10g
  132. Alter tablespace to temporary!!
  133. Raise_application_error drop the error number when displaying
  134. Administration Oracle Database in C#
  135. Trigger help
  136. Startup Options - view
  137. Oracle9IAS: How to archive the application log
  138. Trigger and table
  139. How to give a grant like select,update,insert on a single table
  140. SQL Developer Result & TOAD Result is different
  141. External tables in Oracle
  142. Avoiding multiple reference to same value in Query
  143. Question
  144. HoW???
  145. update column
  146. Time slow by 30mins
  147. multi row update using sub query
  148. Oracle Reports 6i on RDBMS 8i
  149. Services
  150. i am not able to connect any user
  151. fetch the record with maximun seq number
  152. alter database command in Oracle 9i
  153. SQL UPDATE command for updating DATE
  154. Doubt in Reports 6i
  155. How to get the List of Active Users in a Responsibility (Oracle Apps)
  156. Oracle Connection
  157. Extract the 3 most recent dates
  158. how to select Row from the table
  159. Script that searches and updates/deletes
  160. Update command syntax
  161. Date format in Procedure.
  162. SQL Error: Missing IN or OUT parameter at index:: 1
  163. Autonomous_transaction
  164. error while shutdown the database
  165. Error in parsing XML File
  166. wait events
  167. why datadapter do not fill dataset with all changes in database?
  168. Postgres type conflict
  169. XSU.insertXML() type conflict
  170. Didnt get OCA certificate
  171. Oracle HTTP Server Help!
  172. Prepare Statement Limitiations - URGENT ANSWER NEEDED
  173. Create Table In Oracle Procedures
  174. Oracle doubts.
  175. can we write a procedure inside the function?
  176. Date format
  177. help me regarding TNS PROTOCOL ADAPTER ERROR!!!!!!!!
  178. inserting images
  179. What could this question be asking about?
  180. Report builder-Forms builder bugs?
  181. how to insert a single row
  182. Error parsing xml files - Help urgently needed.
  183. Advantages of function overloading
  184. help needed to drop unnames constraint!!!!!!!!
  185. From cursor to a table
  186. Sid, Pid............
  187. Need help in using Radio Buttons, Check Boxes at run Time
  188. "SQL Statement ignored" and "ORA-01733: virtual column not allowed here" errors
  189. catalog.sql, catproc.sql and pupbld.sql
  190. sqlloader
  191. reading a trace
  192. SQL Server Tables Import into Oracle
  193. Dynamic LOVs in Developer 2000 forms 6i
  194. Max value in select statement
  195. begginer
  196. Error in PL/SQL block
  197. insifficient priviliges problem
  198. Send mail from procedure
  199. Oracle Sql
  200. JAVA to ORACLE Date Problems
  201. JOINS In Oracle
  202. How can Stored procedures be used in oracle reports for creating reports?
  203. How Indexes improve performance?
  204. Connect by In Oracle
  205. Update table from Flat file
  206. Pro*C and nested tables compiler error
  207. Not able to user synonyms based on dictionary tables like
  208. Advantages and Disadvantages of a Stored Procedure
  209. Conversion of date format
  210. Grant
  211. database design.(rehan)
  212. how to execute package
  213. optimizing the query
  214. home instance down
  215. IN OUT parameters in Procedures
  216. Oracle spatial
  217. Outside and Within Campus?
  218. Testing of Counters?
  219. Difference between Implicit Cursor and Explicit Cursor
  220. Rem Serveroutput?
  221. PLZ Help to connect to deffrent databases togther
  222. Oracle ORA-01033 Error & ORA-01031 error
  223. What is precompiler
  224. oracle
  225. Blob
  226. Displaying records using %ROWTYPE
  227. india localization oracle fast formulas help
  228. when and why do we need to use pragma serially reusable?
  229. Suse 9 -php 4 - oci8 connection
  230. trigger on AFTER LOGON DATABASE
  231. Declaring a cursor ROWTYPE%
  232. How to solve the restricted data type attribute violation ?
  233. Create any table
  234. how to connect from unix to oracle
  235. Dirrence between VARRAY and Nested Table in PL/SQL
  236. Simple question on how to insert record?
  237. Query behaving differently in different times
  238. What is the use of tnsnames.ora?
  239. oracle Index
  240. Theory questions
  241. sql loader
  242. Pragma autonomous transaction
  243. oracle error..ORA-01858
  244. Hit Ratio of Database Buffer Cache
  245. oracle to postgresSQL
  246. Dynamic %ROWTYPE
  247. How to Unloack Lock
  248. definition of SID in Oracle
  249. Oracle applications 11i installation on WinXp
  250. simulteneous transactions
  251. WITH cluase in Oracle.
  252. What is the Difference Between Oracle 9i and 10g
  253. select statement
  254. difference between case and decode
  255. problem with row_number()
  256. Cbo Rbo
  257. Creating a sequence
  258. index
  259. Swapping tuples using single, simple query
  260. Date Range Criteria with Single Date Prompt
  261. Uninstall Oracle 8
  262. sql query of duplicate records
  263. about oracle 8i
  264. Long-Running Opretations (V$SESSION_LONG_OPS)
  265. oracle statement
  266. Oracle Cursor Problem
  267. help for creating trigger to control the insert according to salary>1000!!!!
  268. dev6i
  269. ORA-03113: end-of-file on communication channel
  270. Help with a Subquery
  271. ASCII Dump of Oracle Table Data
  272. Regarding pl/sql
  273. Converting rows to clumns (max case)
  274. Database Writer / Database Writer I/O salves
  275. "URGENT" please solve oracle9i installation error
  276. new to this group
  277. Need help to import data from excel sheet to oracle database,front end is asp.net
  278. insertion with quick performence
  279. what difference i and g makes in oracle version
  280. to fetch ist 25 rows
  281. package takes long time to run insert statement
  282. need help for oracle insertion
  283. turkish character problem in report builder
  284. oracle sid
  285. oracle report builder
  286. regarding pl/sql sql%notfound
  287. ORA-07445: exception encountered: core dump [FFFFFFFF7E769708] [SIGSEGV] [Address not
  288. pl/sql procedure
  289. Installing ODB.NET
  290. Calling Oracle Stored Procedure from c#.net 2.0
  291. Oracle Stored Proc - Compilation Error
  292. INST Command and help breaking apart Syntax (SQL/Oracle
  293. Any way to stop asterisk translation in a view?
  294. Help needed with String Operation
  295. How can I show the default value?
  296. cursor using join in 8i
  297. can't see the hebrew character
  298. Want to change color of text item when got focus in forms builber d2k
  299. Oracle database creation
  300. Logical & Physical Structure
  301. Table - Logical structure
  302. problem with oracle 10g
  303. password reset plugin
  304. Statistics error
  305. Indexes & Dates
  306. is this syntax right?
  307. Cursor in PL/SQL Oracle
  308. retreiving multiple rows using procedure
  309. Tablespace
  310. problem in oracle apps report while registering reports
  311. oracle10g install on IMacOSX
  312. Oracle Partition
  313. how to disable the item
  314. [1]: (Error): ORA-00907: missing right parenthesis
  315. Integrity Constraints
  316. can we change toolbar and menu bar from oracle report 6 in preview
  317. Db_link
  318. can we connect developer 6i with oracle 10g
  319. hi guys, It's santhosh here,
  320. tns Problem
  321. To make table data case insensitive
  322. Looking for Oracle 8 disks for Linux
  323. need help with dates in teradata
  324. rman backup - retention policy , archive logs
  325. How to find a strucutre of atable in oracle like desc in mysql
  326. Populating Active Directory with data from an Oracle DB
  327. merge hierarchical trees
  328. use of group by with union all
  329. How to store and retrieve an image in oracle using java
  330. Usage Of View
  331. how to migrate oracle to sql
  332. workaround for admin option
  333. Oracle Contains() function won't return rows when Numbers are part of the search term
  334. Reg DMBS Jobs
  335. simple sequence question
  336. Formatting sysdate
  337. 'ORA-00933: SQL command not properly ended' in oracle dtabase
  338. difference between count(*) and count(1)
  339. Oracle OCI for checking the status of database in VC++
  340. ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
  341. Enabling/Disabling Radio Buttons
  342. tablespacing
  343. Can cursor variables be stored in PL/SQL?
  344. How To Restore A Postgres Database Backup In Oracle
  345. Amending a Startup form of an Oracle 6i Application
  346. Oracle 8i installation problem with Windows XP OS
  347. split out duplicate records in Oracle table
  348. import excel worksheet into oracle table
  349. Terminate the scheduled execution job.
  350. Difference Between Oracle6i And Oracle9i
  351. global_database_name in oracle 8i
  352. need help debugging missing parenthesis
  353. How to select data containing newline characters in them.
  354. Triggers in Oracle
  355. (to_char(myDate,format) < myString) vs (myDate < to_date(myString, format)).
  356. file I/O operations
  357. Query using full table scan
  358. query optimisation
  359. Privilege for AFTER LOGON ON DATABASE
  360. Oracle - Rollup not working when I use Having clause
  361. List items in Oracle Forms 6i
  362. Oracle definitions
  363. import data from oracle to MS-Access using forms6i
  364. unique index and non unique index
  365. How to install forms 6i
  366. oracle import only specific user from a dump
  367. possible to create index on a column which contains NULL values
  368. update and insert within the same trigger
  369. handling Long raw data type tables
  370. to see the contents of a view
  371. need a query to display the row value as a column header
  372. Difference between UNION and UNION ALL
  373. possible for function with DML statement to call other function or procedures
  374. Import .xls file into oracle
  375. Using instr and substr
  376. How to create TRIGGERS for inherited types in Oracle
  377. calculate the avg time of two time stamps like start_time and end_tiem
  378. Microsoft OLE DB Provider for Oracle error '80004005'
  379. Connectivity with Oracle8i and Visual Fox Pro at the same time
  380. preserve links while reconciling Oracle Warehouse Builder Premapping operator
  381. Seeking Suggestions
  382. can you commit inside functions
  383. Oracle Query optimization
  384. Functions
  385. Regarding importing of data
  386. database query to show calculated value
  387. question......
  388. preventing sqlplus output to terminal from UNIX
  389. Function return OUT mode
  390. Update record syntax
  391. alter table syntax
  392. problem in creating database
  393. how to write to get a report like....
  394. Trigger valid/invalid
  395. run dbms_stats for a set of tables through a PL/SQL block
  396. Date and time columns - days, hours mins between in SQL
  397. OCI prefetching with ref cursors
  398. how to give prevalages in oracle 9i
  399. what is a virtual table in plsql
  400. Migration from SQL Server Reporting Services to Oracle Reports 10g
  401. How to drop Not Null constraint (system generated)
  402. Explain Plan and Full Table Scan definition
  403. Displaying null value
  404. function truncate
  405. Use functions
  406. Table using joins.
  407. creation of table in procedure, table name as input
  408. what is a virtual table in oracle?can anyone explain pls..
  409. query to match weekly and daily records
  410. Host credentials
  411. FRM-30087: Unable to create form file
  412. select query
  413. DATA prefix on column names
  414. Fast Formulas
  415. locating a particular table or tables in a complete project
  416. Unable to use loop with user input
  417. Unable to close database, get error ORA-01093
  418. Selection Values From 2 Different Rows Of Same Query For Further Calculations
  419. using a ddl statement in a stored procedure
  420. procedure to copy table
  421. Join query not retrieving records
  422. PL/SQL function to invoke the UNIX command doesn't create file
  423. unable to update database
  424. Query
  425. about odbc from forms 6i with micro soft sql server
  426. Find Product Key
  427. Counting number of records in a form
  428. Oracle & ProC
  429. Converting Data to flat file.
  430. Validate a Field in 2 seperate DB ??
  431. Update Query Doubt
  432. Oracle certification
  433. normalization concept with example
  434. Export Oracle Table
  435. Using Parametarized cursor in Execute Immediate
  436. BPEL for integration of web apps
  437. Cant Connect Database
  438. Borland Delphi 6 and Oracle 9i
  439. ORA-01841: (full) year must be between -4713 and +9999, and not be 0
  440. Creation of calender in forms 6i
  441. Installation Problem
  442. To_char(to_date(1234567,'j'),'jsp
  443. How to make column autoincrement in Oracle 9i
  444. Get the Recent Record
  445. function to convert numbers to characters i forms
  446. Left Outer Join with subqueries?
  447. Database error
  448. oracle procedure
  449. Indexes
  450. Back up contents in table data
  451. Oracle table Maintainance.
  452. cursor is open or not?
  453. How to Run Oracle Sequence to MS Access
  454. Problem with query
  455. procedure
  456. Problem with joining two tables
  457. triggers to monitor stock options backdating
  458. choosing index for inner join
  459. choosing index for inner join
  460. woking BLOBS with OLEDB
  461. Persian date on oracle form6i
  462. Oracle and XML
  463. How can i insert thousand records using single query?
  464. update query problem
  465. Accesing another user's Table
  466. Query Help in Teradata
  467. hierarchical tree
  468. How to grant privileges automatically to newly created user?
  469. SQL Query doubt
  470. Rollup and Cube..
  471. REDO Log file corrupted
  472. Use of hierarchical tree in Oracle9i forms
  473. Important - Read Before Posting
  474. Find growth rate of a table
  475. return a variable value in a cursor
  476. SELECT query syntax
  477. Error while trying to load jar file using loadjava
  478. Explain SID and TNS names
  479. extract data from the partitioned table
  480. Oracle9i Form Report connection
  481. Grouping By a To_Char
  482. Oracle 10g OCA and OCP sample questions
  483. PL/SQL equivalent of Select 0, Select 1 etc
  484. Query to find Primary and Foreign keys
  485. Could not create an environment: OCIEnvCreate returned -1.
  486. declaration and scope of variable in procedure
  487. Cascade deleting
  488. What is connect by prior?
  489. to_timestamp fomatting of Dates
  490. ORA-01033 : Oracle Initialization or shutdown in process
  491. "PLS-00201:identifier' <User>.<Procedure Name> ' must be declared"
  492. To_Date in query returns date only
  493. How to update all columns in a table
  494. Sql Date and Time doubt
  495. Tables
  496. Datatype Problem
  497. cx_Oracle.NotSupportedError
  498. Return data from stored procedure
  499. Overloading
  500. Function Overloading
  501. Packages
  502. Some questions..
  503. SQL Query
  504. Dept wise max sal
  505. SELECT query on joined tables
  506. PL/SQL Sorting Function
  507. hOW TO DEVELOP CUSTOMIZE FIELD VARIABLE IN SELECT
  508. D2K problems
  509. usage of Dual table in oracle
  510. SELECT query to find max
  511. Stored Procedures & Oracle
  512. Max(Date) in select query
  513. UNIX script for EXPDP/IMPDP IN Oracle 10g
  514. Mutation table
  515. Records in hirarchial
  516. ORA-01092: ORACLE instance terminated. Disconnection forced
  517. Some questions
  518. the status field value
  519. SELECT query on joined tables
  520. trigger a particular date
  521. How to compare the contents of two tables of identical structure?
  522. UPDATE query
  523. List of tables on which a trigger is used
  524. Joined date
  525. maximum date and not zero records..
  526. the name of a table inside a function
  527. Code Comprehension Exercise
  528. This is the query somebody ask me to do in my first interview of a career.
  529. Need Help for the following Query
  530. update and case clause
  531. Update through join
  532. Problem with MERGE statement
  533. Import Problem
  534. Query Formating In Sql-need help
  535. dynamic cursor?
  536. Duplicates only
  537. Needed Query ..
  538. Oracle Scripts
  539. Dynamic datastructure of objects
  540. query output in CSV
  541. to find top 10 salaries of employees with their names
  542. sql related questions
  543. inserting data into oracle database using perl script
  544. results of left outer join and =(+) in oracle are different
  545. global temporary table.
  546. How to import dBase data to oracle in Linux?
  547. Oracle Errors
  548. siebel
  549. Need help in Update statements with Set for Oracle
  550. oracle pro*C problem:varchar variable is truncated after calling C function