My question has to do with best practices and tools used for promoting application configuration data to a new environment as part of a typical testing cycle. The latter includes three environments, TEST, STAGING and PROD. Code and configuration changes are applied first to test and then promoted to STAGING and then to PROD once tests ha...
I want to write a loop that iterates over numbers 105 102 19 17 101 16 106 107 for each iteration I want to plug the number in a query and insert it into a table. pseudo: LOOP (105 102 19 17 101 16 106 107) FETCH select * from some_table where value=current_iteration_index --105..etc. INTO my_rec_type END LOOP; ...
What am I doing wrong? I need to create the foreign key but the code begining at CONSTRAINT is wrong somehow, also I need help with my view I think im doing the subquery wrong can you help me? CREATE TABLE dealer( dealershipId CHAR(10), phone CHAR(10), dealershipName CHAR(10), webAddress char (10), street CHAR (10), city char (10), zip ...
As I know these two databases are the most popular and the best, but which one is the best? And what are the benefits to use one or other? Currently I use MySQL and I don't really have any experiences with Oracle, but I want to know what's the best choice and why? I mean how fast they are, what kind of features they have, how easy is t...
how can i call a web-service inside a Pl/SQL with a serialize class in the parameters. knowing that i need to get data from pl/sql and pass it to another web-service which will return the result as XML. so shall i take the data from PL/SQL as data-table or can the PL/SQL understand such complex Type as the class. if either of them how...
Im an SQL noob. Heres my situation. I have the following tables. Customer_table Customer_ID | Last name | First Name | City_ID | Region_ID | Country_ID Country_table Country_ID | Country Region_table Region_ID | Region | Country_ID City_table City_ID | City | Region_ID | Country_ID I need to find the number of cus...
Hi, I'm using Oracle 10g Express Edition 10.2 and I use it from a C# application with Oracle.DataAccess 2.111 assembly. I can select data from one table, but if I try to select data from several tables, the set is empty. select * from Table1 works well, but: select * from Table1, Table2 select * from Table1, Table2 where Table1.Id ...
hi how can i run one query in pl-sql- in parallel? i need all the flow... ...
I'm looking for an Oracle database management tool like sql server management studio. I've searched the internet and found a lot of tools on the following link: http://www.freedownloadscenter.com/Search/oracle.html. But I don't know which one is better. I need a stable and easy-to-use GUI tool for working on windows. ...
I am trying to find if a certain column requires TRIM function on it. How can I find out if this column in a table has records that have white space either before or after the actual data. ...
I can get NHibernate (v2) to return and process a single SYS_REFCURSOR that contains my single resultset. Is it possible for multiple resultsets/SYS_REFCURSOR's in NHibernate? What would be the syntax of the .hbm.xml file to map multiple resultsets from the SYS_REFCURSOR's? thanks. ...
query: SELECT A.USER_ID, A.ROLE_ID, C.SUBGROUP, MAX(A.STATUS_ID) FROM USER_ROLE A, USER B, ROLE C WHERE A.ROLE_ID = C.ROLE_ID AND C.GROUP_ID = 3 AND A.USER_ID = B.USER_ID AND B.TEMPLATE_IND = 'N' AND B.ONAP_PARTCODE IS NULL ...
Possible Duplicates: metadata for determining unsed columns How can you tell which columns are unused in ALL_TAB_COLS? Hi, I have to fetch only used column names from all_tab_cols only not unsused ,may i know hidden_column column is marked 'Y' for unused_column only or their some other reasons also. ...
Hi All, I am inserting values in to Database from a Webform using ADO.NET, C#. DB I am using is Oracle Database. Values are not being inserted and the program gets struck at the cmd.ExecuteNonquery() Here is my Code below, Please let me know If I am doing any mistake.. I am using some Static Methods will that be any problem ?.. publ...
I'm in the middle of implementing permissions on a multi-level tabbed/dropdown menu navigation setup. Is there a better method to implementing permissions compared to wrapping each menu item in an if statement? User permissions are stored in a table and pulled in to an array, there are 10 menu items and each menu item has numerous sub-m...
I have a bit of .NET code that retrieves the results from an Oracle Stored Procedure, using the ADO.NET Library, and populates the results into a DataTable like so: using System.Data.OracleClient; public DataTable getData() { OracleConnection conn = new OracleConnection("Data Source=DATASOURCE;Persist Security Info=True;User ID=use...
Hello: I have a simple try/catch block try { // Open the connection _connection.Open(); // [1] } catch( OracleException ex ) // [2] { // Handle the exception int x = ex.ErrorCode; } The catch is never executed and the runtime reports 'OracleException was unhandled' at [1] which just makes my head spin. Clearly, I ...
I've got a permissions/group based setup that I'm trying to merge results on. For example, a user might be associated with four groups: | username | passwd | email | groups | | test_user | 9agb9 | [email protected] | g1, g2, g3, g4 | grouping table: | group | perm1 | perm2 | perm3 | perm4 | perm5 | perm5 | perm7 | | g1 ...
My Oracle query produces the correct result set, but data is being presented with odd characters as you can see by the blocks in the picture below. Any reason that you can think of as to why it would do this and what these characters actually are? Below is the query I'm using. Thanks in advance. SELECT wmsys.wm_concat(userFirstName) ...
Hello people.. I have this persistence unit: <?xml version="1.0" encoding="UTF-8"?> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"> <p...