Search Results

Search found 35371 results on 1415 pages for 'oracle technology network'.

Page 591/1415 | < Previous Page | 587 588 589 590 591 592 593 594 595 596 597 598  | Next Page >

• internal implementation of database Queries

  - by harigm

  In my experience I have used many queries like select, order by, where clause etc.. in mysql, sql-server, oracle etc For a moment i have thought, 1)how is this internally written to implement the above queries 2) which language do they use? 3) is that programming language? if yes which language? 4)what kind of environment required to implement this kind of complex database

  Read the article

• not single-group grouping function while using regr_slope

  - by Peter Kaleta

  HI I try to run : select year, regr_slope(sum(sale_count),year) as slope, from products group by year It throws "00937. 00000 - "not a single-group group function"" .When i delete year from select clause problem disapears. Shouldn't I be able to select column with which I'm grouping? Oracle 11.2 sqldeveloper ty for help !

  Read the article

• Query a stored procedure for it's parameter names and types

  - by ho1

  Is there any easy way to query a stored procedure (Oracle - PL/SQL) for what parameters it expects? I know that I can query USER_SOURCE to get the whole procedure but I'd then have to parse the whole procedure, and if the parameter is of type [table].[column]%TYPE I'd then have to query the table schema as well. Either using just sql or via ODP.Net.

  Read the article

• What is the command for Index optimization and update statistics for Oracle 10g and 11g?

  - by indra

  I am Loading large no of rows into a table from a csv data file . For every 10000 records I want to update the indexs on the table for optimization (update statistics ). Any body tell me what is the command i can use? Also what is MSSQL "UPDATE STATISTICS" equivalent in Oracle.is Update statistics means index optimization or gatehring statistics. I am using Oracle 10g and 11g. Thanks in advance.

  Read the article

• read consistency in transaction Vs locks?

  - by trojanwarrior3000

  In oracle are these concepts- read consistency and locks related or independent ? why read consistency is needed? My assumption is that read consistency is achieved by locks.Is it ?

  Read the article

• Free tool to watch database for changes?

  - by 01

  Im looking for a tool that can watch database(mysql and oracle) for changes. When someone inserts or updates something in any table i want to get to know about it. I know that it can be done using triggers(http://stackoverflow.com/questions/167254/watching-a-table-for-change-in-mysql), but im more interested in some tool that can do it. free tool.

  Read the article

• Question About SQL Query

  - by Ameer

  I am using the below statement to generate age of a person in Oracle SQL and my question is below. SELECT TO_NUMBER(TO_CHAR(CURRENT_DATE,'YYYY'))-TO_NUMBER(TO_CHAR(BIRTH_DATE,'YYYY')) FROM NAME WHERE NAME_ID =NAME_ID This statement is only correct upto so far that I need a statement which could count months and even days in order to get the age.

  Read the article

• SQL Express vs SQL Plus

  - by Bruce227

  Hi, I'm wondering what the difference is if any between SQL Express and SQL Plus. I know SQL Plus is used with Oracle but not sure if SQL Plus is a modification of SQL Express or a totally different installation. Thanks

  Read the article

• How do I return count and not count in a SQL query?

  - by Gribbler

  Hi, If I have a table AgentID | IsNew | TeamID 1 N 1 2 Y 2 3 Y 2 4 N 2 5 Y 1 I want to return the following from a query: Team | CountIsNew = N | CountIsNew = Y 1 1 1 2 1 2 Is there a way I can do this? Using Oracle 10

  Read the article

• Are there any downsides in using C++ for network daemons?

  - by badcat

  Hey guys! I've been writing a number of network daemons in different languages over the past years, and now I'm about to start a new project which requires a new custom implementation of a properitary network protocol. The said protocol is pretty simple - some basic JSON formatted messages which are transmitted in some basic frame wrapping to have clients know that a message arrived completely and is ready to be parsed. The daemon will need to handle a number of connections (about 200 at the same time) and do some management of them and pass messages along, like in a chat room. In the past I've been using mostly C++ to write my daemons. Often with the Qt4 framework (the network parts, not the GUI parts!), because that's what I also used for the rest of the projects and it was simple to do and very portable. This usually worked just fine, and I didn't have much trouble. Being a Linux administrator for a good while now, I noticed that most of the network daemons in the wild are written in plain C (of course some are written in other languages, too, but I get the feeling that 80% of the daemons are written in plain C). Now I wonder why that is. Is this due to a pure historic UNIX background (like KISS) or for plain portability or reduction of bloat? What are the reasons to not use C++ or any "higher level" languages for things like daemons? Thanks in advance! Update 1: For me using C++ usually is more convenient because of the fact that I have objects which have getter and setter methods and such. Plain C's "context" objects can be a real pain at some point - especially when you are used to object oriented programming. Yes, I'm aware that C++ is a superset of C, and that C code is basically C++. But that's not the point. ;)

  Read the article

• QueryTables error

  - by ktm5124

  I have the following VBA code inside an Excel macro: With ActiveSheet.QueryTables.Add( _ Connection:=ConnStr, _ Destination:=ActiveSheet.Range("A1"), _ Sql:=SqlStr) .Refresh End With And yet I am getting the error: "Run-time error '1004': Application-defined or object-defined error." The debugger points to this code as the source of error. Assuming that my ConnStr and SqlStr are correct, why am I getting this error? I am using Excel 2007 and I am querying an Oracle database.

  Read the article

• Update multiple table column values using single query

  - by Dave Jarvis

  How would you update data in multiple tables using a single query? In MySQL it would be: UPDATE party p LEFT JOIN party_name n ON p.party_id = n.party_id LEFT JOIN party_details d ON p.party_id = d.party_id LEFT JOIN incident_participant ip ON ip.party_id = p.party_id LEFT JOIN incident i ON ip.incident_id = i.incident_id SET p.employee_id = NULL, c.em_address = '[email protected]', c.ad_postal = 'x', n.first_name = 'x', n.last_name = 'x' WHERE i.confidential_dt IS NOT NULL What is the equivalent SQL statement using Oracle 11g? (Is ANSI SQL possible?) Thank you!

  Read the article

• Is there a nvl() function in Ruby or do I have to write it myself?

  - by jva

  I want to use an equivalent of Oracle's nvl() function in Ruby. Is there a built in function or do I have to write one myself?

  Read the article

• Foreign Keys and Primary Keys at the same time

  - by Bader

  hello , i am trying to create table (orderdetails) , the table has two FKs and PKs at the same keys here is my code create table OrderDetails2 ( PFOrder_ID Number(3) PFProduct_ID Number(3) CONSTRAINT PF PRIMARY KEY (PFOrder_ID,PFProduct_ID), CONSTRAINT FK_1 FOREIGN KEY (PFProudct_ID) REFERENCES Product(Product_ID), CONSTRAINT FK_2 FOREIGN KEY (PFOrder_ID) REFERENCES Orderr(Order_ID) ); i am using Oracle express , a problem pops when i run the code , here is it ORA-00907: missing right parenthesis what is the problem ?

  Read the article

• optimizing the sql query by not repeating the math..

  - by user333747

  Here is the query in Oracle I was trying to remove the redundant math operation from: SELECT name, CASE when nvl(num1,0) + nvl(num2,0) - nvl(num3,0) > 0 THEN nvl(num1,0) + nvl(num2,0) - nvl(num3,0) ELSE 0 END as result, .... from .... How do I not repeat the summation above?

  Read the article

• manipluation 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

• need help with a simple SQL update statement.

  - by Tony

  There's a field with type of varchar. It actually stores a float point string. Like 2.0 , 12.0 , 34.5 , 67.50 ... What I need is a update statement that remove the ending zeros of fields like 2.0 , 12.0 , change them to their integer representation , that is 2 , 12 ...,and leave 3.45 , 67.50 unchanged . How should I do this ? I am using oracle 10.

  Read the article

• How can I get a COUNT(col) ... GROUP BY to use an index?

  - by thecoop

  I've got a table (col1, col2, ...) with an index on (col1, col2, ...). The table has got millions of rows in it, and I want to run a query: SELECT col1, COUNT(col2) WHERE col1 NOT IN (<couple of exclusions>) GROUP BY col1 Unfortunately, this is resulting in a full table scan of the table, which takes upwards of a minute. Is there any way of getting oracle to use the index on the columns to return the results much faster?

  Read the article

• How to select a row with a missing entry in historization?

  - by Viper

  from the following data basis i need to select all IDQ's which do not have an entry for the 11.11.2011. IDQ | DATE ---------------- 1 | 08.11.2011 1 | 09.11.2011 1 | 10.11.2011 1 | 12.11.2011 1 | 13.11.2011 i can't figure out how to express the sql select IDQ from TBL_WITH_IDQ T where not exists ( DATE = '11.11.2011' ) // sql does not the job Database is a Oracle 11g. maybe someone can help me?

  Read the article

• SQL to have one specific record at the top, all others below

  - by superdario

  Hey all, I am trying to put together a query that will display one specific record (found by the record's primary ID) at the top, and display all other records below it, sorted by date (I have "date_added" as one of the fields in the table, in addition to primary ID). I could do this with a UNION (first select would locate the record I want, and the other select would display all other records), but I'm wondering if is there perhaps a better way? I'm using Oracle, by the way.

  Read the article

• utl_file.FCLOSE() is slow with large files

  - by Dan

  We are using utl_file in Oracle 10g to copy a blob from a table row to a file on the file system and when we call utl_file.fclose() it takes a long time. It's a 10mb file, not very big, and it takes just over a minute to complete. Anyone know why this would be so slow? Thanks

  Read the article

• 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

• [C# Thread] I'd like access to a share on the network!

  - by JustLooking

  Some Details I am working with VisualWebGUI, so this app is like ASP.NET, and it is deployed on IIS 7 (for testing) For my 'Web Site', Anonymous Authentication is set to a specific user (DomainName\DomainUser). In my web.config, I have impersonation on. This is how I got my app to access the share in the first place. The Problem There is a point in the the app where we use the Thread class, something similar to: Thread myThread = new Thread(new ThreadStart(objInstance.PublicMethod)); myThread.Start(); What I have noticed is that I can write to my logs (text file on the share), everywhere throughout my code, except in the thread that I kicked off. I added some debugging output and what I see for users is: The thread that's kicked off: NT AUTHORITY\NETWORK SERVICE Everywhere else in my code: DomainName\DomainUser (described in my IIS setup) OK, for some reason the thread gets a different user (NETWORK SERVICE). Fine. But, my share (and the actual log file) was given 'Full Control' to the NETWORK SERVICE user (this share resides on a different server than the one that my app is running). If NETWORK SERVICE has rights to this folder, why do I get access denied? Or is there a way to have the thread I kick off have the same user as the process?

  Read the article

< Previous Page | 587 588 589 590 591 592 593 594 595 596 597 598  | Next Page >