select sid from V$mystat where rownum =1;
Monday, August 24, 2009
Subscribe to:
Post Comments (Atom)
Social Profiles
-
SAP HANA: SAP HANA converges database and application platform capabilities in-memory to transform transactions, analytics, ...
-
where clause with ntext in SQL server: I have a column of type ntext in SQL server how can I evaluate it in a WHERE clause. Structu...
-
SSIS: Connect to Oracle - Cannot retrieve the column code page info from the OLE DB Provider I have tried to access data in Oracle from...
-
About Sysname: The sysname data type is used for table columns, variables, and stored procedure parameters that store object names. The exa...
-
Error Message: in SQL server An error occurred while executing batch. Error message is: The directory name is invalid. Reason: This err... -
Question: Are UNION and OR doing to same or different? Comments: We check with some data. Scripts: create table test_tab ( num1 numb...
-
Schema Binding : Creating a view with the SCHEMABINDING option locks the tables being referred by the view and prevents any changes that ma...
-
Get month value from Date in SQL server: Sample: select month(getdate()) as month_num, datename(month,getdate()) as month_name month...
-
Stored procedure to read the filenames: create procedure spReadFolder @path sysname as begin set nocount on declare @dirfile table( id int...
-
The SQL CREATE TABLE statement allows you to create and define a table. Each column must have a data type. The column should either be defi...
Karthikeyan Baskaran
OCA
Blogger news
0 comments:
Post a Comment