Search Results

Search found 22352 results on 895 pages for 'oracle projects'.

Page 410/895 | < Previous Page | 406 407 408 409 410 411 412 413 414 415 416 417  | Next Page >

• 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

• How can I add two projects. Visual Studio 2008

  - by masfenix

  I just created a project so my Solution Explorer looks like this: But I want to add another project which is related to this project but it's going to be a class library and it's going to output a DLL that I could use in any other project. So how can I create a "solution" with multiple projects?

  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

• What do you use to do DRY web development (SASS+HAML, LessCSS, etc) in non-Ruby projects?

  - by T.R.

  I've been looking to make things a little more DRY, both on my personal projects (django) and at work (JSP/struts,PHP). SASS+HAML seem to be quite popular, but, do those outside of the Rails community generally use these as well, or do they opt for other similar solutions? Which do you use, and what was the reasoning behind the choice?

  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

• Rails 3 beta 3 -- is it time to start using this for new projects?

  - by TMB

  Is it time to start new projects in Rails 3? I'm nervous about using beta versions but at the same time I really like what they are doing and don't want to deal with legacy 2.3.5 issues with these apps. Is it better to wait these things out, or buckle-up, deal with early adopter issues and get a head start on the future. Thanks for any light you can shed.

  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

• 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

• Should i include all my projects/applications in my resume?

  - by Pandiya Chendur

  I am an asp.net developer with 1-2 yrs experience and thus far worked with 7-10 asp.net websites... Should i include all my projects/applications with details in my resume when applying for a postion of asp.net developer with 1-2 years experience...

  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

• How are open source projects in C/C++ carried out exactly without .sln/.project files?

  - by httpinterpret

  Seems most open source projects in C/C++ only provide the source code,i.e. nginx Is this a convention that anyone interested in joining the developing team should figure out the .sln/.project files himself to qualify??

  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

• Sharing assembly code between WPF, Silverlight and Windows Phone: quite impractical for big projects !

  - by user310291

  It is said here: http://blogs.msdn.com/b/mikeormond/archive/2010/12/09/writing-cross-platform-xaml-applications.aspx Within Visual Studio, if you add files to the project via “Add Existing Item”, and select the “Add As Link” option you can work on the same file from multiple projects. Oh my I'm on a project which have multiple countries, brands, components layers and each time I will add a file you want me to "Add as Link" ? This is a nightmare maintenance ! Is there any other solutions ?

  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

• C#, can we share some contents of App.config between projects?

  - by 5YrsLaterDBA

  I have two independent projects in my Visual Studio 2008 solution. Both has its own App.config. But in one project, I need one or two properties defined in another project's App.config. Is it possible to share part of the App.config contents from other project?

  Read the article

• Is learning Dependency Injection worth it for someone that usually only does small projects(5-20k li

  - by devoured elysium

  I just usually do applications for myself as a hobby. It looks like DI frameworks have a big momentum in the community, so I thought maybe I should learn it to improve my coding skills. From what I understand, it seems to be geared more towards big projects. Is it still a good idea to use it for example in a 5k lines project? Thanks

  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

• 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 | 406 407 408 409 410 411 412 413 414 415 416 417  | Next Page >