SQL & PL/SQL :: How To Find Who Created The Table In Oracle
Feb 8, 2011somebody has created the table , who had created the table Note: not required the schema name,
View 4 Replies
ADVERTISEMENT
Server Administration :: Find When Database Role Created And Who Has Created?
Feb 14, 2013Is there a way to find when was a database role created and who has created?
View 5 Replies View RelatedSQL & PL/SQL :: Find Final Text Of Dynamic Query Created By Dbms_sql?
Jul 4, 2012I am using dbms_sql for creation and execution of dynamic query. But after execution,the results returned are not correct. Just wanted to know is there some way by which I can find the final text of dynamic query created by dbms_sql?
View 14 Replies View RelatedPL/SQL :: Find Previous Value From Oracle Table
Jun 4, 2013I have a stat table that got info like login_date,user_id etc.For a specific user, i have a requirement based on the no of days difference between the current login date and last login date.
For example, Tom logged in on June 4th 2013. His previous login was May 31. So no_of_days_difference is 5 days.How to programmatically get this for each user inside a pl-sql sub block.
REFRESH GROUP Is Automatically Created When A Materialized View Is Created?
Aug 17, 2012tell me if a REFRESH GROUP is automatically created when a materialized view is created?
View 3 Replies View RelatedSQL & PL/SQL :: Logic To Find Table Names And Data In Oracle?
Feb 1, 2013I have a schema DEF and I have a column_name CREATE_DATE.
I wanted to write a procedure which will give me list of tables whose CREATE_DATE data is prior to year 2009.
SQL & PL/SQL :: How To Know Index Is Created On Table Or Not
Jun 30, 2011how to know weather procedure is working or not in a database ..
how to know index is created on table or not.
PL/SQL :: How Many Foreign Key Can Be Created On Table
May 3, 2013in a table how many foreign keys can we create.
View 10 Replies View RelatedSecurity :: How To Configure Oracle EM With Newly Created Oracle Instance On 10g DB
Dec 11, 2012How to configure Oracle EM with newly created Oracle Instance on Oracle 10g DB,which is Single Instance DB but not RAC ,when I start the Oracle EM it is starting the default DB which created during Oracle Server Installation.
View 0 Replies View RelatedSQL & PL/SQL :: Created Table With Date In Database
Feb 22, 2011Me working on Oracle application Express,there are lots of tables created in it, how will i get to know who created which table and on which date.
View 7 Replies View RelatedSQL & PL/SQL :: Make Partition Of Table Which Is Already Created
Sep 21, 2011I want to make partition of table which is already created and has huge amount of Data I have done indexing already
my structure are as follows
EMPLOYEE CHAR(10),
MONTH_YEAR NUMBER (6),
TYPE CHAR (1),
SALARY_CODE CHAR (5),
AMOUNT NUMBER (16,2)
Indexing on Employee,Month,Salary_Code
How can I do partitioning on this table.
SQL & PL/SQL :: Date Search - No Index Created On Table
Feb 25, 2010DT1 is a column of date datatype and there is no index created on the table
I want to add the below lines in the sql
TO_CHAR(DT1,'YYYY') BETWEEN '2005' AND '2009'
Which one should I use in where condition to query and why?
1. TO_CHAR(DT1,'YYYY') BETWEEN '2005' AND '2009'
2. DT1 BETWEEN '01/01/2005' AND '31/12/2009' (as NLS date format will not change)
3. DT1 BETWEEN to_date('01/01/2005','dd/mm/yyyy') AND ('31/12/2009' ,'dd/mm/yyyy')
Forms :: Use Created Table In Data Block?
May 1, 2013I have data that the user is modifying on the form and a data block that is supposed to reflect those change (summaries) So I created
TYPE VehicleInfo IS RECORD (Vehicle_Desc ctl_fleet_vehicles.Vehicle_Desc%Type,
Miles timecapture.miles%Type,
Hours TimeCapture.Equipment_hours%Type);
TYPE VehicleTab IS TABLE OF VehicleInfo
INDEX BY BINARY_INTEGER;
VehicleObj VehicleTab;
I fill this up with the correct data, but I would like to be able to use this as a table in the data block (called Vehicle_Summary) In the past I have piped tables into data blocks from the server, but I'm unsure how to use a table I created in forms in the Query Data Source Name of the data block.
PL/SQL :: Created A Table With CLOB As Datatype For One Of Columns
Aug 5, 2013<ORACLE VERSION : 11.2.0.2.0> i have created a table with CLOB as datatype for one of the columns, I am trying to store a string ( I am not sure about the length of the string) , when i am querying on my table for the CLOB column,instead of the actual string "(HUGECLOB)" is coming. How to get the actual string in case the problem is with the SIZE.
View 1 Replies View RelatedPL/SQL :: Created Partition And Parallel Degree 4 On Table A
Oct 10, 2012I have table A with size 120 Million and two more tables are of size 2 Million on Table B and less than 1 Million size on table C.I had created Partition and Parallel degree 4 on the table A. Created table B with Parallel degree 2 and Created table C with NOPARALLEL.
My query is using above tables with joins and inserting into table D using HINT /*+ APPEND NOLOGGING*/I had executed the explain on the above criteria the cost is showing 20767.
Later created Tables A,B and C with NOPARALLEL. Applied HINT on Table D /*+ APPEND NOLOGGING*/ and als applied HINT /*+ PARALLEL(A, 4) PARALLEL(B C, 2) on select query which uses to insert into Table D.
My question which is best practice on PARALLEL degree creation at table level or query level:
a) Creating table with Paralle (degree 4)
b) Applying HINT /*+ PARALLEL (TABLE A , 4) */ at query level
SQL & PL/SQL :: Employee Table In Scott Schema Created By Default
Oct 3, 2011I am using Oracle 11g Release 11.2.0.1.0
OS: Windows
I am using the Employee table in Scott schema which created by default.
10,20,30,40,50 are the department ids.
I would like to have the output like below. I am having lots of values in dep id and lots of employees in each dept ids
Emp name Dep ID
John 20
Mike 40
Ram 10
Guru 50
Kumar 30
Source SQL For Oracle View Created
Apr 15, 2013Is there a way to find the source sql that created a view? Do you know the sql the sql that created a view?
View 5 Replies View RelatedSQL & PL/SQL :: Select All Users Created By Oracle?
May 4, 2012During installation of a database Oracle creates several users. Also when using DBCA in a later stage to add more options Oracle can create more users.
Here's my problem: Public synonyms never get exported using exp(dp)/imp(dp) utility. Ofcourse using public synonyms isn't good practise, but sometimes handy. Unfortunately in our environment they have been used a lot in the passed.
So I want to create an SQL statement that does the trick and returns only all users that were NOT created by Oracle software.
I've tried several things, but can't seem to distinguish Oracle users from Manually created users.
Forms :: Created Block For Table On Tabular Style - Validating Item?
Oct 10, 2011I created a block for EMP table on tabular style. if in first line empno entered is 1then i don't want to allow the end user to enter 1 in second line. but when-validate-item is not working because first_record and next_record is not allowed. I need to validate before saving the data into emp table and immediately after empno is entered into empno item.
View 16 Replies View RelatedServer Administration :: Event Alert Created Successfully On Custom Table But Not Firing?
Mar 8, 2013I have created custom table in inventory and after register table & columns, i create event alert on it. event alert is not firing.
View 1 Replies View RelatedOracle 10g - Associate Created View With Certain Level Of Security
Nov 12, 2006I have the following questions :
1. After creating a view, how do I associate that view with certain level of security. As in, only a few users must be allowed to access that view.
2. How can I create a new user-login and password for my database application?
Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database
Dec 27, 2012how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.
View 1 Replies View RelatedServer Administration :: Jobs Created When Upgrade To Oracle 11.1 Version?
Feb 8, 2012what jobs will be created when we upgrade to oracle 11.1 version ?
View 4 Replies View RelatedSQL & PL/SQL :: Exception In Procedure / Created One Procedure Based On One Table Item Master
Mar 6, 2010I have created one procedure based on one table item master which has a field called item stock or non stock based on this i will fetch data from one of two tables .If its a stock item data will be retrieved from wip_main_acnt table and if its non stock it will pick from ns_main_acnt.my procedure is working fine but all i need is i just want to put an exception that if data is not found in one of the table based on the item selected.I am confused which one to be used whether no_data_found or notfound%.
CREATE OR REPLACE PROCEDURE dflt_pr_acnt (
l_item_code IN VARCHAR2,
l_main_acnt_code OUT VARCHAR2
)
[code]....
How To Find Table Fragmentation
Jul 22, 2011A query to find the table fragmentation.
View 1 Replies View RelatedHow To Find Table For Script
Aug 19, 2010i have table like TWRCHAIN_WS_SUM. it is regularly updated by another object like procedure, function. how can i find which object is updating the particular table across the database.
View 4 Replies View RelatedUnable To Find A Table?
Mar 22, 2011why am i getting this?
SQL> SELECT TABLE_NAME,owner from dba_TABLES where TABLE_NAME in ('BSNL_ACCOUNT_DATA','BSNL_SERVICE_DATA','BSNL_PKG_DETAILS');
TABLE_NAME OWNER
------------------------------ ------------------------------
BSNL_ACCOUNT_DATA BPREAD
BSNL_SERVICE_DATA BPREAD
but the table exists
SQL> select count(*) from BPREAD.BSNL_PKG_DETAILS;
COUNT(*)
----------
3704
SQL> select TABLE_NAME,owner from dba_TABLES where TABLE_NAME='BSNL_PKG_DETAILS';
no rows selected
why is it showing no rows even if the table exists
Find Out Row Count From Each Table?
May 6, 2009I have written a script to get count of each tables of a schema.
DECLARE CURSOR c1 IS
select distinct table_name from all_tab_columns where OWNER='PLAY';
countrows NUMBER;
[Code].....
Find Out Row Count From Each Table
Mar 31, 2009SQL> select count(*) from tab;
COUNT(*)
----------
63
I need to find out how many rows in each table.I've tried with cursor.
SQL & PL/SQL :: How To Find Table That Contains Certain Column
Nov 9, 2011To find out column in which table it is located.
View 1 Replies View Related