Search Results

Search found 21481 results on 860 pages for 'oracle business intellige'.

Page 439/860 | < Previous Page | 435 436 437 438 439 440 441 442 443 444 445 446  | Next Page >

• Can MySQL do row level security or what Oracle calls virtual private databases?

  - by JavaRocky

  Does MySQL have any equivalent feature to Oracle's virtual private databases in 10g. It is also known as row level security. I prefer not to implement anything like columns and triggers. I am looking for a solution similar to Oracle's.

  Read the article

• Update table with if statement PS/SQL

  - by Matt

  I am trying to do something like this but am having trouble putting it into oracle coding. BEGIN IF ((SELECT complete_date FROM task_table WHERE task_id = 1) IS NULL) THEN UPDATE task_table SET complete_date = //somedate WHERE task_id = 1; ELSE UPDATE task_table SET complete_date = NULL; END IF; END; But this does not work i also tried IF EXISTS(SELECT complete_date FROM task_table WHERE task_id = 1) with no luck

  Read the article

• How can you tell which columns are unused in ALL_TAB_COLS?

  - by thecoop

  When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?

  Read the article

• How do I print a triangle of stars using SQL

  - by Vutukuri

  Is it practically possible to create a triangle of stars like this as below in SQL.I know that this could be done easily in any other programming language like C,C++,Java but want to know whether it is really possible with just SQL or PL/SQL.I tried working on it with dual table in Oracle but couldn't get through it. * * * * * * * * * or * * * Can someone please shed somelight if anyone knows about it.

  Read the article

• How to show 0 when no row found

  - by user1685991

  I have a SQL query in which I am passing sysdate to the query problem is that when there is no matching date in table with sysdate then it don't shows the zero even if there is nvl applied here is my query select * from molasses where trunc(trn_dte) = trunc(sysdate) But it show data only when current date is present in table but I want to show zero if no data found in table.please help me to do this in oracle 10 g. Because some times the situation is like above and I have to display zero when no data found

  Read the article

• Is there a way to parametrize ORACLE 10g SELECT-query with IN-clause (C#/ADO.NET 2.0)

  - by matti

  I saw couple of SO questions (SO) concerning SQL-server. For SQL-server there was no decent solution. All were hacks/workarounds. What about Oracle? Is it same answer (Paremeterizing each value)? Any Oracle example without LINQ would be appreciated (I have .NET 2.0). Thanks & BR -Matti

  Read the article

• Do views only perform the joins that they need to, or all joins always?

  - by Nate

  I am on an oracle DB. Lets say I have one view that joins to three tables. The view has two fields each. Each field only needs data from two of the three tables. If I query the view and return only one field, does the view still join to three tables or just to the two tables that it needs to calculate the field?

  Read the article

• Why is COBOL still a preferred language in the business world?

  - by equilibrium

  Even though we have languages like C++, Java, Python etc., why is COBOL still a preferred language in the business world? EDIT: Why was it so popular? Sorry for not creating a separate thread for this question.

  Read the article

• Extract ODBC Data Source information

  - by Zack

  I've gone through ODBC API searching for a function that can extract information of a data source. The closest I found is SQLDataSources that enumerates all data sources and gives you the DSN name/description. But specifically I would to extract the TNS service name of an Oracle data source. This property appears in the registry under ServerName but I found no way to access it through an API.

  Read the article

• PL/SQL REGEXP_LIKE testing string for allowed characters

  - by Arino

  I need to verify that the provided string has only allowed characters using Oracle regular expressions (REGEXP_LIKE). Allowed chars are: abcdefghijklmnopqrstuvwxyz0123456789_-. Trying to execute SELECT CASE WHEN REGEXP_LIKE('abcdefghijklmnopqrstuvwxyz0123456789_-.' , '^[a-z0-9_\-\.]+$') THEN 'true' ELSE 'false' END tmp FROM dual; results in 'false'. Any ideas on this?

  Read the article

• Reasons why I still use MS-DOS 6.22 for certain applications.

  - by Frank Developer

  For single-user small business applications. (no desire for internet) Small Footprint (fast loading, fast performance, fast boot/shutdown) Reliable!

  Read the article

• How to trim all columns in all rows in all tables of type string?

  - by daveslab

  Hi folks, In Oracle 10g, is there a way to do the following in PL/SQL? for each table in database for each row in table for each column in row if column is of type 'varchar2' column = trim(column) Thanks!

  Read the article

• How do I check whether the table has a record with a primary key values?

  - by KIM

  I have a exception to prevent inserting same records on my oracle. I've haerd that COUNT(*) has lots of cost which I don't want to use. Is there any alternative way to make it at least cost?

  Read the article

• Maximum capabilities of MySQL

  - by cdated

  How do I know when a project is just to big for MySQL and I should use something with a better reputation for scalability? Is there a max database size for MySQL before degradation of performance occurs? What factors contribute to MySQL not being a viable option compared to a commercial DBMS like Oracle or SQL Server?

  Read the article

• What's the limit of BONITA Platform ? Can a Business Analyst generate a whole Java Web App with just

  - by asksuperuser

  I'm studying some systems that allow faster App dev cycles. So I stumbled upon BONITA. It seems that by preparing some connectors you can allow a Business to generate a whole App. What's the limit of Bonita and what is needed to improve it ?

  Read the article

• Where is all_nested_table_cols in 9i?

  - by thecoop

  Oracle 9i has nested tables, however it doesn't have the all_nested_table_cols sysview (like 10g and 11g) which lets me see what the columns are for these nested tables. How can I find this information on a 9i database?

  Read the article

• How can I find columns which have non-null values?

  - by aartist

  I have many columns in oracle database and some new are added with values. I like to find out which columns have values other than 0 or null. So I am looking for column names for which some sort of useful values exists at least in one row. How do I do this? Update: This sounds very close. How do I modify this to suit my needs? select column_name, nullable, num_distinct, num_nulls from all_tab_columns where table_name = 'SOME_TABLE'

  Read the article

• what is a candidate row in SQL?

  - by JuiceBerry123

  What is a candidate row when talking about Oracle and SQL? Using it in a sentence would be as such: "The candidate row is fetched from the table specified in the outer query."

  Read the article

• Is it possible to get local business results through the Google APIs?

  - by chris

  Is it easy to get the business listings such as when you search in Google Maps? If there is an API that would be great! In any language, preferable, PHP or javascript

  Read the article

• Getting all rows from a Table where the column contains only 0

  - by Auro

  I got a little problem i need a sql query that gives all rows back that only contains 0 in it. the column is defined as varchar2(6) the values in the column looks like this: 0 00 00 100 bc00 000000 00000 my first solution would be like this: Oracle: substr('000000' || COLUMN_NAME, -6) = '000000' SQL Server: right('000000' + COLUMN_NAME, 6) = '000000' is there an other way? (it needs to work on both systems)

  Read the article

• NUL symbol gets inserted anywhere in the XML

  - by Racs

  I am using Oracle 11g and when I query data from database manually, it looks ok. But when I view it using Notepad++, there is a special character that gets inserted anywhere in the xml produced. Please see image below: I tried everything and deleted some parts of the xml, updated the db and query again but the invalid character just differ in location. Any idea is much appreciated, thanks! Best regards, Racs

  Read the article

• manupluation of date in vb

  - by banita

  how can we extract system time in vb and do calculation ie. adding or subtracing time then store change time in oracle database table in earlier format .

  Read the article

• Sort chars in varchar2 alphabetically

  - by mtim

  I'm looking for a function that would sort chars in varchar2 alphabetically. Is there something built-in into oracle that I can use or I need to create custom in PL/SQL ?

  Read the article

• Where this Telerik OpenAccess sits within Business Objects and Data Layer Objetcs?

  - by dewacorp.alliances

  HI there We are exploring Telerik OpenAccess and traditionally we have Business Objects as well as Data Objects. With the introducing of Telerik OpenAccess ORM thingy, where this persistenobjects sits? Is it going to replace the Data Layer objects? I am appreciated your comment. Thanks

  Read the article

• SQL How to convert a decimal to a string

  - by theringostarrs

  In a SELECT statement I want to convert values to strings ie. SELECT TO_STRING(value). How can I do this in Oracle SQL?

  Read the article

< Previous Page | 435 436 437 438 439 440 441 442 443 444 445 446  | Next Page >