For e.g. Create table tempOCT as Select....If i run the code in any day of Nov the table name should be tempNOV.

vishal gupta

• Nov 21st, 2007

You can do one this?in the code itself that is going to create the table at run time incorporate the logic to get the currect date,?take it as string variable and then in the code itself you can write the query?Create table as(..)Might help you.Vishal.

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

I think it is not possible, i try to concate date with table name but no vail.You can not rename the table name by cancating date

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

 SELECT BYTES/1024     FROM DBA_EXTENTS  WHERE OWNER = 'SCOTT'       AND SEGMENT_NAME = 'EMP';  This will return you size of table in Kilo Bytes.  User is Scott and Table is Emp.

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

ALTER TABLE table_nameADD CONSTRAINT table_column_pk PRIMARY KEY (column_name);It is a table level primary key constraint applied on an existing table. SELECT TO_CHAR(DOB, 'DD-MM-YYYY')   FROM table_name;

Answer Question  Select Best Answer

Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screenCan be row level or statement level No distinction between row level and statement level.Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.Can be fired from any...

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

Database Trigger: We can't invoke a Form Trigger in DatabaseFrom Trigger: We can invoke a Database Trigger in Forms

Mohit Dhamija

• Jul 3rd, 2006

Even 'Form Trigger' can be fired before and after the event. ex- Triggers like Pre Block / Pre Record / Post Block / Post Record ..

Answer Question  Select Best Answer

CD

• Nov 5th, 2007

You may use a functions called 'characters'.Syntax:characters ()

Answer Question  Select Best Answer

Choose - Choose either Rule based or Cost based depend on theavailability of statistics. If statistics is available on the table it usesCBO and if not it uses RBO.       ALL_ROWS - Choose based optimization, statistics is needed. U couldpass as hint in ur query.But in the majority of cases with optimizer_mode=choose ( and with a goodstatistics ) the CBO will be able to find a good...

Manoj Seemar

 Profile Answers by Manoj Seemar Questions by Manoj Seemar

• Nov 2nd, 2007

The OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an optimization approach for the instance.CHOOSEThe optimizer chooses between a cost-based approach and a rule...

Answer Question  Select Best Answer

vidya

• Oct 30th, 2007

Where clause doesnt allow group functions.You need to use Having Clause.i.e Having count(*)>1

ROHIT_4444

 Profile Answers by ROHIT_4444 Questions by ROHIT_4444

• Mar 28th, 2007

IN THIS PREV NO EXPRESSION I PUT = IT WORK BUT ONLY SIMILAR EXACT QUERY IS DELETE FROM  WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM  GROUP BY <DUPLICATE VALUE FIELD NAME);IT'S WORK SURE

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 28th, 2007

1. When you create more indexes on a table , for example  table A has 10 columns and you have create 8 indexes on that table. Then whenever you r going to retrieve data from that table each row o...

Sushma

• Jul 11th, 2007

3.If we have the null values in the column then we can not create primary key trigger on that column.4. It is an event that raised implicitly when you update the table.Regards,Sushma

Answer Question  Select Best Answer

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

As in case of normalization and properly index conditions and order of coulumns are not require to care the pointer of the new record created at last. This will be managed by the indexes and orders of...

Madhu

• Mar 24th, 2007

Suppose a table dept contains 3 columns say deptno,dname and loc.If u want to change the order of dname and loc in reverse,then write  a query as followscreate table dept1 as  (select deptno,loc,dname from dept);drop table dept;create table dept as (select * from dept1); 

Answer Question  Select Best Answer

Dhaval

• Nov 14th, 2006

Select Count(*) , DATEPART ( hh , sellgoodsdate) From goodssellGroup By DATEPART ( hh , sellgoodsdate)

Answer Question  Select Best Answer

vaibhav Tyagi

 Profile Answers by vaibhav Tyagi Questions by vaibhav Tyagi

• Oct 21st, 2007

Create proc EarnMoneyProcasdeclare @earn int,@total int,@tempday int,@TotDays int set @earn=1set @tempday=1set @total=0set @Totdays = 50*365print @Totdayswhile(@tempday <= @Totdays  )beginset @earn = @earn + 2;set @tempday =@tempday+1print @earnendprint @total

Srinivasa Pavan

• Jan 9th, 2007

hai allam a new to this site and i can give a solution to this Question and here is the coding for that.declare result number :=1;inc number ?:=2;year number :=1;i number;beginwhile??(?year?<=50?)?...

Answer Question  Select Best Answer

vaibhav Tyagi

 Profile Answers by vaibhav Tyagi Questions by vaibhav Tyagi

• Oct 21st, 2007

ROWLOCK Use row-level locks when reading or modifying data. PAGLOCK Use page-level locks when reading or modifying data. TABLOCK Use a table lock when reading or modifying data. DBLOCK Use a database...

Answer Question  Select Best Answer

deviji2000

 Profile Answers by deviji2000 Questions by deviji2000

• Oct 15th, 2007

hi,   v use joins to get details from both the tables thz kind of joins r called  outer joins   to get the missed statements.select  e.eno, e.ename, e.deptnofrom emp e, d...

Nandakumar

• Jan 28th, 2007

Yes, you can get all the departments along with the employee details, plus the department for which no employee exists. Here you go using outerjoin, select a.employee_id, a.email, a.salary, a.departm...

Answer Question  Select Best Answer

raj1402

 Profile Answers by raj1402 Questions by raj1402

• Oct 12th, 2007

You can use oracle as Database and Jsp for scripting!!!

prasadmeduri

 Profile Answers by prasadmeduri Questions by prasadmeduri

• Feb 14th, 2006

Hi,You can use any type of webapplications for this task.I think ASp/JSP will be of great use and benefit.Keep database(SQLServer or Oracle) and your IIS/Weblogic on one dedicated machine for ser...

Answer Question  Select Best Answer

I dont knowplz give the ans. through my email

Priestly George Varghese

• Oct 10th, 2007

If you are creating trigger using before keyword, then the trigger will fire before the particular query.If you are creating trigger using?after keyword, then the trigger will fire?after the particular query.

REDDY

• Nov 18th, 2005

Your question is not clear, when creating triggers we give the trigger timing (i.e) BEFORE or AFTER and the trigger will file accordinglycreate or replace trigger <trigger name>  timing <...

Answer Question  Select Best Answer

select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') <'col_name')group by level;Example:Given a table called emp with the following columns:-- id number-- name varchar2(20)-- sal number---- For the second lowest salary:-- select level, min(sal) from emp-- where level=2-- connect by prior sal < sal-- group by level

NITYANAND

• Oct 7th, 2007

TO find out nth LOWEST value, e.g. salary from emp table without using ROWNUM & DESC/ASCSELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal))     &...

Ishita

• Oct 4th, 2007

Easiest wayselect top 1 name from emp where name>(select min(name) from emp) order by nameIshita.

Answer Question  Select Best Answer

If your answer is yes, explain the steps.

gkbiswal

 Profile Answers by gkbiswal Questions by gkbiswal

• Sep 29th, 2007

Yes we can.create or replace trigger trg_testbefore insert on empbeginnull;end;create synonym trg_syn for trg_test;

Answer Question  Select Best Answer