I want to use unique sys_guid() for insert multiple table but out put are difference sys_guid() drop table T1; drop table T2; drop table T3; create table T1 (ROW_ID varchar2(50)); create table T2 (ROW_ID varchar2(50)); create table T3 (ROW_ID varchar2(50)); insert all into T1 values (NEW_ROW_ID) into T2 values (NEW_ROW_ID) into T3 values (NEW_ROW_ID) select [...]
Answer Question | November 26, 2012 12:40 PM
Oracle 9, Oracle SQL
how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows
Answer Question | May 22, 2012 11:28 AM
Oracle Query, Oracle SQL
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]
Answer Question | March 31, 2012 7:12 PM
Oracle, Oracle SQL, SQL, SQL Server
I WANT TO CREATE A TABLE WITH THE COLUMN NAME AS DATE BUT IT SHOWING THE ERROR.BUT I WANT TO DISPLAY COLUMN NAME AS DATE ONLY CAN ANY ONE HELP i try it SQL> create create table store_information(store_name varchar2(10),sales varchar2(10),date date); create create table store_information(store_name varchar2(10),sales varchar2(10),date date) * ERROR at line 1: ORA-00901: [...]
Answer Question | June 13, 2011 12:39 PM
Oracle administration, Oracle SQL, Oracle SQL Developer
Hi , i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query . return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]
Answer Question | May 16, 2011 5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
converting double byte characters to single byte characters in a single string
Answer Question | April 12, 2011 9:58 PM
Double-byte, Oracle SQL, Oracle SQL Developer, Single Byte
Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer’s SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers
Answer Question | February 11, 2011 8:13 AM
Oracle SQL, Oracle SQL Developer, SQL, SQL Server
What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.
Answer Question | November 26, 2010 7:18 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?
Answer Question | November 15, 2010 10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement
Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?
Answer Question | April 22, 2010 11:26 AM
Microsoft SQL Server, OLTP, Oracle SQL
Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005.
Answer Question | January 20, 2010 10:42 AM
Oracle, Oracle 9i, Oracle SQL, SQL
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?
Answer Question | August 25, 2009 2:52 AM
Oracle SQL, WinSQL, WINSQL Numeric Function
When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I’m using Oracle 9i Personal Edition
Answer Question | August 21, 2009 6:41 AM
ORA-01034, ORA-27101, Oracle SQL, SQL Plus
Can u please give me a list pf SR’s u have solved ?
Answer Question | August 18, 2009 6:22 AM
Oracle Service Request, Oracle SQL, Oracle SR, PL/SQL
I am a beginner at SQL… I’ve come across a situation maybe someone can help me out. I have a table with the following structure: bkt_id am bkt_101 bkt_102 bkt_103 … bkt_228 bkt_101 $100 $100 $20 $0 bkt_102 $50 $100 $20 $0 … I want to compare am with the proper bkt_n value using the [...]
Answer Question | July 24, 2009 1:31 AM
Excel HLOOKUP function, Oracle, Oracle 10g, Oracle SQL, SQL
I want to connect 2pcs’s having oracle 9i (sever version) installed in them ,through a broadband connection(ie. a dynamic IP). Can any one show me the way.
Answer Question | April 28, 2009 4:39 PM
Dynamic IP address, Oracle SQL
I have procedure iven below Output of the procedure below is multiple rows but i am getting only 1st row how to use concept of SYS_REFCURSOR over here CREATE OR REPLACE procedure Vishal_PROC_sp1 (kpiid in number, val1 out varchar2, val2 OUT Number) as cursor c1 is select kpimainid,sysdate,selectstmt,clause,to_char(sysdate,’MON’) month,cautionmax,cautionmin from kpimain where kpimainid = kpiid; [...]
Answer Question | April 30, 2009 7:25 PM
Oracle SQL, Oracle stored procedures, SYS_REFCURSOR
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case [...]
Answer Question | April 22, 2009 2:39 AM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad’s save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case when old_mdn is null then [...]
Answer Question | April 15, 2009 12:46 PM
Oracle Database, Oracle Output Via SQL, Oracle SQL
why is the need of psql when the sql is already avaliable.
Answer Question | March 30, 2009 7:43 AM
Oracle SQL, PL/SQL, SQL, SQL development