Latest Answer : If you are trying SQL Server 2000, try the code that gives the size in bytes...DECLARE @CalSize TABLE( TabID INT, ColSize INT)INSERT INTO @CalSize SELECT A.id, SUM(A.Length) As Length FROM (Select Length, id from ...
I want to develop a reservation system database(just like at indian railways ticketing counters)using oracle in which i can connect 2 computers by networkingcan u plz suggest which languages in oracle i should useand what applications of those would help me
..........
Latest Answer : Oracle is a Database Management System SQL is a language used to query the database ...
In Mysql, which one character is used to complete the query and get the input. In other words, we can write the query in multiple lines. How to terminate the query?
semicolon ' ; '
Hey there SQL MASTERS, here are some questions i was posed in an interview/assessment thing, dunno how well i did....Coud u answer these questions? i dont know how easy/difficut they are for u, all i know is that i had SERIOUS trouble with them! thanks alot!EMPLOYEEEmployee_id number NOT NULL (Primary Key)Employee_name VarChar(30) NOT NULL Dept_id number NOT NULL (Foreign Key to DEPARTMENT)Manager_id number NOT NULL (Foreign Key to EMPLOYMENT)Salary number
Latest Answer : In Trigger there is a special Table Called INSERTD. it takes the value from transation log.In the After Insert Trigger....SELECT Id,Name FROM INSERTEDyou can catch these values in a variable. ...
In SQL, I'm analyzing a cluster for a san and I'm not sure if I'm doing it properly. If I ask how many transactions are too many, is there a straight answer? For instance, SQL trace monitored for 5 days, and found 37,405,636 transaction recorded, 0 errors, with 36,346,652 number of stored procedures executed. How does one tell if this is normal or not?
I am writing a script to update a value in an Oracle table. The script has a 'From' clause which Oracle does not like. Is there another way to write this since I am bringing data from 3 different tables.ThanksSamir
Latest Answer : FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME) IN EMP TABLE:SELECT COLUMN_NAME FROM USER_TAB_COLUMNSWHERE TABLE_NAME ='EMP'AND COLUMN_ID = 2 ...
Latest Answer : check this link.....http://asktom.oracle.com/pls/ask/f?p=4950:8:16663421538065257584::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:766825833740 ...