Forums Page 89
-
column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery fname||lname like "'%"||p_lname||"'" It keeps giving me syntax…
-
Linking with Foreign Keys
I have been getting an erro when I try and link: create table Faculty_Specialty (I_Name varchar2(20) not null, Specialty varchar2(40) not null)…
-
Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think. SQL> select prclid from parcel 2 where expdate = ''; no rows selected…
-
how make 2 column in table with data tybe long row
hi every one I want make in my table 2 column with data tybe long raw how this thanks
-
records between 2 dates
Hello all, I have a date tracked table which contains effective_start_date and effective_end_date fields where we have the start date and end dates…
-
HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values. I need to use DBMS_SQL in order to execute them. In theese SQL…
- Advertisement
-
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all, i want to know the queries issued by various users accessing a database... But the in view DBA_AUDIT_TRAIL,I was getting empty value...(in…
-
updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels. I know I can update 1 with…
-
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all, i want to know the queries issued by various users accessing a database... But the in view DBA_AUDIT_TRAIL,I was getting empty value...(in…
-
Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any docs is appreciated...) All of the docs I've looked…
-
Request for tunning the below query
Hi, Can any one help me on the below query while improving the performance, SELECT accdet, acceprec, accinvalid, accnetanal, accphy, accvalid…
-
quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows SQL> execute :myvariable:=dbms_flashback.get_system_change_number()…
-
Varible in trigger - refering to correct schema
Hello Im having some issues with my trigger. What I want to do is call opon a different schema - depending on which data the triggers picks up. For…
-
Calling a Procedure with IN & OUT Parameters
Hello, I usually call my procedures using the following way declare variable error_msg varchar2(50) exec simple_msg('ABC,'ABC','ABC',:error_msg)…
- Advertisement
-
why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ? Thanks select salary from employees union select salary from…
-
with clause
hi all, i have a big query that usually access the same table more than once. for example, i have something like this select <column list> from…
-
All possible combinations of Strings from table in PL/SQL
Hi, I am trying to figure out how to build a list of all possible string combinations from values stored in a single table. There are multiple…
-
Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in the table. How can I add these missing weeks with a…
-
All possible combinations of String in PL/SQL
Hi All, Could you please explain the logic of getting all possible combinations of String in PL/SQL? For ex if "HER" is string then the output should…
-
Loop Through Date Range
Hi guys, I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop through this date range and want to get date like…